{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}F:\fiscal research\mayor\PSRM data\PSRM_Analaysis_log.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}19 Dec 2023, 09:24:35
{txt}
{com}. 
. ** Log file for Analysis: Table 1, Table 2, Table B.6, Table B.7, Table B.8 **
. 
. 
. xtset geo_fips year
{res}{txt}{col 8}panel variable:  {res}geo_fips (unbalanced)
{txt}{col 9}time variable:  {res}{col 25}year, 2005 to 2020
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. 
. 
. 
. * Table 1 (and Table B.4)
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0275{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0533{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0194{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}567{txt}){col 67}={col 70}{res}    12.71
{txt}corr(u_i, Xb){col 16}= {res}-0.5563{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 84:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 19}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 20}{c |}{col 32}    Robust
{col 1}fed_act_yr_city_~c{col 20}{c |}      Coef.{col 32}   Std. Err.{col 44}      t{col 52}   P>|t|{col 60}     [95% Con{col 73}f. Interval]
{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_party {c |}{col 20}{res}{space 2} .2075642{col 32}{space 2} .8818234{col 43}{space 1}    0.24{col 52}{space 3}0.814{col 60}{space 4}-1.524475{col 73}{space 3} 1.939603
{txt}{space 8}ln_tot_pop {c |}{col 20}{res}{space 2} 26.79118{col 32}{space 2} 16.77852{col 43}{space 1}    1.60{col 52}{space 3}0.111{col 60}{space 4}-6.164459{col 73}{space 3} 59.74683
{txt}{space 6}ln_income_pc {c |}{col 20}{res}{space 2}-17.80961{col 32}{space 2} 25.11259{col 43}{space 1}   -0.71{col 52}{space 3}0.478{col 60}{space 4}-67.13467{col 73}{space 3} 31.51546
{txt}{space 10}pov_rate {c |}{col 20}{res}{space 2}-26.63902{col 32}{space 2} 76.43748{col 43}{space 1}   -0.35{col 52}{space 3}0.728{col 60}{space 4}-176.7742{col 73}{space 3} 123.4962
{txt}{space 18} {c |}
{space 14}year {c |}
{space 13}2006  {c |}{col 20}{res}{space 2}-1.213086{col 32}{space 2} 1.786125{col 43}{space 1}   -0.68{col 52}{space 3}0.497{col 60}{space 4}-4.721315{col 73}{space 3} 2.295144
{txt}{space 13}2007  {c |}{col 20}{res}{space 2} 1.135975{col 32}{space 2} 1.944165{col 43}{space 1}    0.58{col 52}{space 3}0.559{col 60}{space 4}-2.682669{col 73}{space 3} 4.954619
{txt}{space 13}2008  {c |}{col 20}{res}{space 2} 21.04202{col 32}{space 2} 2.860032{col 43}{space 1}    7.36{col 52}{space 3}0.000{col 60}{space 4} 15.42447{col 73}{space 3} 26.65957
{txt}{space 13}2009  {c |}{col 20}{res}{space 2} 24.28139{col 32}{space 2} 6.157462{col 43}{space 1}    3.94{col 52}{space 3}0.000{col 60}{space 4} 12.18717{col 73}{space 3} 36.37561
{txt}{space 13}2010  {c |}{col 20}{res}{space 2} 12.58639{col 32}{space 2} 2.852852{col 43}{space 1}    4.41{col 52}{space 3}0.000{col 60}{space 4} 6.982943{col 73}{space 3} 18.18984
{txt}{space 13}2011  {c |}{col 20}{res}{space 2} 11.23656{col 32}{space 2} 3.154948{col 43}{space 1}    3.56{col 52}{space 3}0.000{col 60}{space 4} 5.039744{col 73}{space 3} 17.43337
{txt}{space 13}2012  {c |}{col 20}{res}{space 2} 1.081599{col 32}{space 2} 3.292043{col 43}{space 1}    0.33{col 52}{space 3}0.743{col 60}{space 4} -5.38449{col 73}{space 3} 7.547688
{txt}{space 13}2013  {c |}{col 20}{res}{space 2} 1.351409{col 32}{space 2} 3.633382{col 43}{space 1}    0.37{col 52}{space 3}0.710{col 60}{space 4}-5.785122{col 73}{space 3} 8.487941
{txt}{space 13}2014  {c |}{col 20}{res}{space 2}  2.16935{col 32}{space 2} 3.926553{col 43}{space 1}    0.55{col 52}{space 3}0.581{col 60}{space 4}-5.543016{col 73}{space 3} 9.881716
{txt}{space 13}2015  {c |}{col 20}{res}{space 2} 3.439091{col 32}{space 2} 4.067837{col 43}{space 1}    0.85{col 52}{space 3}0.398{col 60}{space 4}-4.550779{col 73}{space 3} 11.42896
{txt}{space 13}2016  {c |}{col 20}{res}{space 2}-1.247289{col 32}{space 2} 4.712388{col 43}{space 1}   -0.26{col 52}{space 3}0.791{col 60}{space 4}-10.50316{col 73}{space 3}  8.00858
{txt}{space 13}2017  {c |}{col 20}{res}{space 2}-1.431942{col 32}{space 2} 5.580156{col 43}{space 1}   -0.26{col 52}{space 3}0.798{col 60}{space 4}-12.39224{col 73}{space 3} 9.528358
{txt}{space 13}2018  {c |}{col 20}{res}{space 2} 3.618021{col 32}{space 2} 6.582193{col 43}{space 1}    0.55{col 52}{space 3}0.583{col 60}{space 4}-9.310437{col 73}{space 3} 16.54648
{txt}{space 13}2019  {c |}{col 20}{res}{space 2} 13.93309{col 32}{space 2} 7.402554{col 43}{space 1}    1.88{col 52}{space 3}0.060{col 60}{space 4}-.6066899{col 73}{space 3} 28.47286
{txt}{space 13}2020  {c |}{col 20}{res}{space 2} 14.94538{col 32}{space 2} 10.75859{col 43}{space 1}    1.39{col 52}{space 3}0.165{col 60}{space 4}-6.186176{col 73}{space 3} 36.07693
{txt}{space 18} {c |}
{space 13}_cons {c |}{col 20}{res}{space 2}-120.7139{col 32}{space 2} 349.7657{col 43}{space 1}   -0.35{col 52}{space 3}0.730{col 60}{space 4}-807.7085{col 73}{space 3} 566.2808
{txt}{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
           sigma_u {c |} {res} 26.142338
           {txt}sigma_e {c |} {res} 48.834655
               {txt}rho {c |} {res} .22274028{txt}   (fraction of variance due to u_i)
{hline 19}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) replace
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc.tex"'"':R1_final_fed_act_con_pc.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.strong_mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0279{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0535{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0201{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}567{txt}){col 67}={col 70}{res}    12.57
{txt}corr(u_i, Xb){col 16}= {res}-0.5361{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  fed_act_yr_city_2012_pc{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.strong_mayor_pres_party {c |}{col 27}{res}{space 2}  3.21007{col 39}{space 2}  1.18703{col 50}{space 1}    2.70{col 59}{space 3}0.007{col 67}{space 4} .8785563{col 80}{space 3} 5.541584
{txt}{space 15}ln_tot_pop {c |}{col 27}{res}{space 2}  25.7551{col 39}{space 2} 16.80348{col 50}{space 1}    1.53{col 59}{space 3}0.126{col 67}{space 4}-7.249559{col 80}{space 3} 58.75977
{txt}{space 13}ln_income_pc {c |}{col 27}{res}{space 2}-17.51133{col 39}{space 2}   25.041{col 50}{space 1}   -0.70{col 59}{space 3}0.485{col 67}{space 4}-66.69578{col 80}{space 3} 31.67311
{txt}{space 17}pov_rate {c |}{col 27}{res}{space 2}-28.08637{col 39}{space 2} 76.19899{col 50}{space 1}   -0.37{col 59}{space 3}0.713{col 67}{space 4}-177.7531{col 80}{space 3} 121.5804
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2006  {c |}{col 27}{res}{space 2}-1.211168{col 39}{space 2} 1.786229{col 50}{space 1}   -0.68{col 59}{space 3}0.498{col 67}{space 4}-4.719602{col 80}{space 3} 2.297266
{txt}{space 20}2007  {c |}{col 27}{res}{space 2} .9785189{col 39}{space 2} 1.921939{col 50}{space 1}    0.51{col 59}{space 3}0.611{col 67}{space 4} -2.79647{col 80}{space 3} 4.753508
{txt}{space 20}2008  {c |}{col 27}{res}{space 2} 20.85542{col 39}{space 2} 2.837093{col 50}{space 1}    7.35{col 59}{space 3}0.000{col 67}{space 4} 15.28292{col 80}{space 3} 26.42791
{txt}{space 20}2009  {c |}{col 27}{res}{space 2} 23.85107{col 39}{space 2} 6.122915{col 50}{space 1}    3.90{col 59}{space 3}0.000{col 67}{space 4} 11.82471{col 80}{space 3} 35.87744
{txt}{space 20}2010  {c |}{col 27}{res}{space 2} 12.19955{col 39}{space 2} 2.812504{col 50}{space 1}    4.34{col 59}{space 3}0.000{col 67}{space 4} 6.675349{col 80}{space 3} 17.72374
{txt}{space 20}2011  {c |}{col 27}{res}{space 2} 10.84864{col 39}{space 2} 3.113743{col 50}{space 1}    3.48{col 59}{space 3}0.001{col 67}{space 4} 4.732766{col 80}{space 3} 16.96452
{txt}{space 20}2012  {c |}{col 27}{res}{space 2} .7423288{col 39}{space 2} 3.254455{col 50}{space 1}    0.23{col 59}{space 3}0.820{col 67}{space 4}-5.649931{col 80}{space 3} 7.134589
{txt}{space 20}2013  {c |}{col 27}{res}{space 2} 1.037007{col 39}{space 2} 3.594353{col 50}{space 1}    0.29{col 59}{space 3}0.773{col 67}{space 4}-6.022865{col 80}{space 3} 8.096879
{txt}{space 20}2014  {c |}{col 27}{res}{space 2} 1.860754{col 39}{space 2} 3.884305{col 50}{space 1}    0.48{col 59}{space 3}0.632{col 67}{space 4} -5.76863{col 80}{space 3} 9.490138
{txt}{space 20}2015  {c |}{col 27}{res}{space 2} 3.162622{col 39}{space 2} 4.027355{col 50}{space 1}    0.79{col 59}{space 3}0.433{col 67}{space 4}-4.747735{col 80}{space 3} 11.07298
{txt}{space 20}2016  {c |}{col 27}{res}{space 2}-1.539577{col 39}{space 2} 4.683258{col 50}{space 1}   -0.33{col 59}{space 3}0.742{col 67}{space 4}-10.73823{col 80}{space 3} 7.659076
{txt}{space 20}2017  {c |}{col 27}{res}{space 2}-1.543785{col 39}{space 2} 5.560667{col 50}{space 1}   -0.28{col 59}{space 3}0.781{col 67}{space 4}-12.46581{col 80}{space 3} 9.378236
{txt}{space 20}2018  {c |}{col 27}{res}{space 2} 3.499251{col 39}{space 2} 6.562792{col 50}{space 1}    0.53{col 59}{space 3}0.594{col 67}{space 4}-9.391102{col 80}{space 3}  16.3896
{txt}{space 20}2019  {c |}{col 27}{res}{space 2} 13.82126{col 39}{space 2} 7.373719{col 50}{space 1}    1.87{col 59}{space 3}0.061{col 67}{space 4}-.6618748{col 80}{space 3}  28.3044
{txt}{space 20}2020  {c |}{col 27}{res}{space 2} 14.85492{col 39}{space 2} 10.72912{col 50}{space 1}    1.38{col 59}{space 3}0.167{col 67}{space 4}-6.218745{col 80}{space 3} 35.92858
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2}-111.7592{col 39}{space 2} 349.5803{col 50}{space 1}   -0.32{col 59}{space 3}0.749{col 67}{space 4}-798.3897{col 80}{space 3} 574.8712
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 25.723299
                  {txt}sigma_e {c |} {res} 48.823035
                      {txt}rho {c |} {res} .21727626{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc.tex"'"':R1_final_fed_act_con_pc.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0283{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0541{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0210{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}567{txt}){col 67}={col 70}{res}    12.79
{txt}corr(u_i, Xb){col 16}= {res}-0.5013{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 90:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 26}{c |}{col 38}    Robust
{col 1} fed_act_yr_city_2012_pc{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_gover_party {c |}{col 26}{res}{space 2} 3.544585{col 38}{space 2} 1.140764{col 49}{space 1}    3.11{col 58}{space 3}0.002{col 66}{space 4} 1.303946{col 79}{space 3} 5.785224
{txt}{space 14}ln_tot_pop {c |}{col 26}{res}{space 2} 24.28075{col 38}{space 2} 16.74551{col 49}{space 1}    1.45{col 58}{space 3}0.148{col 66}{space 4}-8.610053{col 79}{space 3} 57.17155
{txt}{space 12}ln_income_pc {c |}{col 26}{res}{space 2} -15.9578{col 38}{space 2} 25.18384{col 49}{space 1}   -0.63{col 58}{space 3}0.527{col 66}{space 4} -65.4228{col 79}{space 3}  33.5072
{txt}{space 16}pov_rate {c |}{col 26}{res}{space 2}-18.19832{col 38}{space 2} 77.15795{col 49}{space 1}   -0.24{col 58}{space 3}0.814{col 66}{space 4}-169.7486{col 79}{space 3}  133.352
{txt}{space 24} {c |}
{space 20}year {c |}
{space 19}2006  {c |}{col 26}{res}{space 2}-1.263381{col 38}{space 2} 1.786087{col 49}{space 1}   -0.71{col 58}{space 3}0.480{col 66}{space 4}-4.771535{col 79}{space 3} 2.244773
{txt}{space 19}2007  {c |}{col 26}{res}{space 2} .9913083{col 38}{space 2} 1.925279{col 49}{space 1}    0.51{col 58}{space 3}0.607{col 66}{space 4}-2.790242{col 79}{space 3} 4.772859
{txt}{space 19}2008  {c |}{col 26}{res}{space 2} 20.83092{col 38}{space 2} 2.846938{col 49}{space 1}    7.32{col 58}{space 3}0.000{col 66}{space 4} 15.23908{col 79}{space 3} 26.42275
{txt}{space 19}2009  {c |}{col 26}{res}{space 2}  23.9598{col 38}{space 2} 6.118405{col 49}{space 1}    3.92{col 58}{space 3}0.000{col 66}{space 4}  11.9423{col 79}{space 3} 35.97731
{txt}{space 19}2010  {c |}{col 26}{res}{space 2} 12.35534{col 38}{space 2} 2.821102{col 49}{space 1}    4.38{col 58}{space 3}0.000{col 66}{space 4} 6.814254{col 79}{space 3} 17.89643
{txt}{space 19}2011  {c |}{col 26}{res}{space 2} 11.01263{col 38}{space 2}   3.1252{col 49}{space 1}    3.52{col 58}{space 3}0.000{col 66}{space 4} 4.874246{col 79}{space 3} 17.15101
{txt}{space 19}2012  {c |}{col 26}{res}{space 2} .8411747{col 38}{space 2} 3.273691{col 49}{space 1}    0.26{col 58}{space 3}0.797{col 66}{space 4}-5.588868{col 79}{space 3} 7.271217
{txt}{space 19}2013  {c |}{col 26}{res}{space 2} 1.154915{col 38}{space 2} 3.606574{col 49}{space 1}    0.32{col 58}{space 3}0.749{col 66}{space 4}-5.928961{col 79}{space 3}  8.23879
{txt}{space 19}2014  {c |}{col 26}{res}{space 2} 1.904782{col 38}{space 2} 3.911374{col 49}{space 1}    0.49{col 58}{space 3}0.626{col 66}{space 4}-5.777769{col 79}{space 3} 9.587334
{txt}{space 19}2015  {c |}{col 26}{res}{space 2} 3.366514{col 38}{space 2} 4.036805{col 49}{space 1}    0.83{col 58}{space 3}0.405{col 66}{space 4}-4.562403{col 79}{space 3} 11.29543
{txt}{space 19}2016  {c |}{col 26}{res}{space 2}-1.350973{col 38}{space 2} 4.688103{col 49}{space 1}   -0.29{col 58}{space 3}0.773{col 66}{space 4}-10.55914{col 79}{space 3} 7.857197
{txt}{space 19}2017  {c |}{col 26}{res}{space 2}-1.773044{col 38}{space 2} 5.589773{col 49}{space 1}   -0.32{col 58}{space 3}0.751{col 66}{space 4}-12.75223{col 79}{space 3} 9.206147
{txt}{space 19}2018  {c |}{col 26}{res}{space 2} 3.242166{col 38}{space 2} 6.588805{col 49}{space 1}    0.49{col 58}{space 3}0.623{col 66}{space 4}-9.699279{col 79}{space 3} 16.18361
{txt}{space 19}2019  {c |}{col 26}{res}{space 2} 13.68103{col 38}{space 2} 7.395727{col 49}{space 1}    1.85{col 58}{space 3}0.065{col 66}{space 4}-.8453378{col 79}{space 3} 28.20739
{txt}{space 19}2020  {c |}{col 26}{res}{space 2} 14.70791{col 38}{space 2} 10.75213{col 49}{space 1}    1.37{col 58}{space 3}0.172{col 66}{space 4} -6.41095{col 79}{space 3} 35.82678
{txt}{space 24} {c |}
{space 19}_cons {c |}{col 26}{res}{space 2}-111.3824{col 38}{space 2} 349.1647{col 49}{space 1}   -0.32{col 58}{space 3}0.750{col 66}{space 4}-797.1965{col 79}{space 3} 574.4317
{txt}{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                 sigma_u {c |} {res} 25.042923
                 {txt}sigma_e {c |} {res} 48.814911
                     {txt}rho {c |} {res} .20835181{txt}   (fraction of variance due to u_i)
{hline 25}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc.tex"'"':R1_final_fed_act_con_pc.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.str_mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0282{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0538{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0208{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}567{txt}){col 67}={col 70}{res}    12.50
{txt}corr(u_i, Xb){col 16}= {res}-0.5093{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 94:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 29}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 30}{c |}{col 42}    Robust
{col 1}     fed_act_yr_city_2012_pc{col 30}{c |}      Coef.{col 42}   Std. Err.{col 54}      t{col 62}   P>|t|{col 70}     [95% Con{col 83}f. Interval]
{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.str_mayor_pres_gover_party {c |}{col 30}{res}{space 2} 5.222594{col 42}{space 2} 1.661454{col 53}{space 1}    3.14{col 62}{space 3}0.002{col 70}{space 4} 1.959239{col 83}{space 3} 8.485949
{txt}{space 18}ln_tot_pop {c |}{col 30}{res}{space 2} 24.59242{col 42}{space 2} 16.78486{col 53}{space 1}    1.47{col 62}{space 3}0.143{col 70}{space 4}-8.375682{col 83}{space 3} 57.56053
{txt}{space 16}ln_income_pc {c |}{col 30}{res}{space 2} -16.4454{col 42}{space 2} 25.07502{col 53}{space 1}   -0.66{col 62}{space 3}0.512{col 70}{space 4}-65.69667{col 83}{space 3} 32.80587
{txt}{space 20}pov_rate {c |}{col 30}{res}{space 2}-22.92242{col 42}{space 2} 76.60545{col 53}{space 1}   -0.30{col 62}{space 3}0.765{col 70}{space 4}-173.3875{col 83}{space 3} 127.5427
{txt}{space 28} {c |}
{space 24}year {c |}
{space 23}2006  {c |}{col 30}{res}{space 2}-1.231642{col 42}{space 2}  1.78586{col 53}{space 1}   -0.69{col 62}{space 3}0.491{col 70}{space 4}-4.739352{col 83}{space 3} 2.276067
{txt}{space 23}2007  {c |}{col 30}{res}{space 2} .9882831{col 42}{space 2} 1.922444{col 53}{space 1}    0.51{col 62}{space 3}0.607{col 70}{space 4}-2.787697{col 83}{space 3} 4.764263
{txt}{space 23}2008  {c |}{col 30}{res}{space 2}  20.8316{col 42}{space 2} 2.835756{col 53}{space 1}    7.35{col 62}{space 3}0.000{col 70}{space 4} 15.26173{col 83}{space 3} 26.40146
{txt}{space 23}2009  {c |}{col 30}{res}{space 2} 23.95138{col 42}{space 2} 6.110425{col 53}{space 1}    3.92{col 62}{space 3}0.000{col 70}{space 4} 11.94955{col 83}{space 3} 35.95322
{txt}{space 23}2010  {c |}{col 30}{res}{space 2} 12.33401{col 42}{space 2}  2.81495{col 53}{space 1}    4.38{col 62}{space 3}0.000{col 70}{space 4} 6.805004{col 83}{space 3} 17.86301
{txt}{space 23}2011  {c |}{col 30}{res}{space 2} 10.89004{col 42}{space 2} 3.117797{col 53}{space 1}    3.49{col 62}{space 3}0.001{col 70}{space 4} 4.766197{col 83}{space 3} 17.01388
{txt}{space 23}2012  {c |}{col 30}{res}{space 2} .7939545{col 42}{space 2} 3.258831{col 53}{space 1}    0.24{col 62}{space 3}0.808{col 70}{space 4}-5.606899{col 83}{space 3} 7.194808
{txt}{space 23}2013  {c |}{col 30}{res}{space 2} 1.065216{col 42}{space 2} 3.595101{col 53}{space 1}    0.30{col 62}{space 3}0.767{col 70}{space 4}-5.996124{col 83}{space 3} 8.126557
{txt}{space 23}2014  {c |}{col 30}{res}{space 2} 1.867765{col 42}{space 2} 3.887531{col 53}{space 1}    0.48{col 62}{space 3}0.631{col 70}{space 4}-5.767955{col 83}{space 3} 9.503486
{txt}{space 23}2015  {c |}{col 30}{res}{space 2} 3.399628{col 42}{space 2} 4.020626{col 53}{space 1}    0.85{col 62}{space 3}0.398{col 70}{space 4}-4.497512{col 83}{space 3} 11.29677
{txt}{space 23}2016  {c |}{col 30}{res}{space 2}-1.340185{col 42}{space 2}  4.67514{col 53}{space 1}   -0.29{col 62}{space 3}0.774{col 70}{space 4}-10.52289{col 83}{space 3} 7.842523
{txt}{space 23}2017  {c |}{col 30}{res}{space 2}-1.714057{col 42}{space 2} 5.566812{col 53}{space 1}   -0.31{col 62}{space 3}0.758{col 70}{space 4}-12.64815{col 83}{space 3} 9.220034
{txt}{space 23}2018  {c |}{col 30}{res}{space 2} 3.312003{col 42}{space 2} 6.565339{col 53}{space 1}    0.50{col 62}{space 3}0.614{col 70}{space 4}-9.583351{col 83}{space 3} 16.20736
{txt}{space 23}2019  {c |}{col 30}{res}{space 2}  13.6577{col 42}{space 2} 7.376583{col 53}{space 1}    1.85{col 62}{space 3}0.065{col 70}{space 4}-.8310691{col 83}{space 3} 28.14646
{txt}{space 23}2020  {c |}{col 30}{res}{space 2} 14.68155{col 42}{space 2} 10.72841{col 53}{space 1}    1.37{col 62}{space 3}0.172{col 70}{space 4}-6.390733{col 83}{space 3} 35.75383
{txt}{space 28} {c |}
{space 23}_cons {c |}{col 30}{res}{space 2}-109.3715{col 42}{space 2}  348.921{col 53}{space 1}   -0.31{col 62}{space 3}0.754{col 70}{space 4}-794.7071{col 83}{space 3} 575.9642
{txt}{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                     sigma_u {c |} {res} 25.197117
                     {txt}sigma_e {c |} {res} 48.815382
                         {txt}rho {c |} {res} .21038076{txt}   (fraction of variance due to u_i)
{hline 29}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc.tex"'"':R1_final_fed_act_con_pc.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc.txt""':seeout}

{com}. 
. 
. 
. ** Table 2 (and Table B.5): By President Party **
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     4,307
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       555

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0319{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.0315{col 63}{txt}avg{col 67}={col 69}{res}       7.8
{txt}     overall = {res}0.0098{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}554{txt}){col 67}={col 70}{res}    12.00
{txt}corr(u_i, Xb){col 16}= {res}-0.9369{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 84:(Std. Err. adjusted for {res:555} clusters in geo_fips)}
{hline 19}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 20}{c |}{col 32}    Robust
{col 1}fed_act_yr_city_~c{col 20}{c |}      Coef.{col 32}   Std. Err.{col 44}      t{col 52}   P>|t|{col 60}     [95% Con{col 73}f. Interval]
{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_party {c |}{col 20}{res}{space 2} 1.989347{col 32}{space 2} 2.235265{col 43}{space 1}    0.89{col 52}{space 3}0.374{col 60}{space 4}-2.401284{col 73}{space 3} 6.379979
{txt}{space 8}ln_tot_pop {c |}{col 20}{res}{space 2} 98.11329{col 32}{space 2} 39.88936{col 43}{space 1}    2.46{col 52}{space 3}0.014{col 60}{space 4} 19.76041{col 73}{space 3} 176.4662
{txt}{space 6}ln_income_pc {c |}{col 20}{res}{space 2}-67.76682{col 32}{space 2} 51.06579{col 43}{space 1}   -1.33{col 52}{space 3}0.185{col 60}{space 4}-168.0731{col 73}{space 3} 32.53942
{txt}{space 10}pov_rate {c |}{col 20}{res}{space 2}-94.02858{col 32}{space 2} 227.0586{col 43}{space 1}   -0.41{col 52}{space 3}0.679{col 60}{space 4}-540.0296{col 73}{space 3} 351.9724
{txt}{space 18} {c |}
{space 14}year {c |}
{space 13}2010  {c |}{col 20}{res}{space 2}-11.72277{col 32}{space 2} 4.844355{col 43}{space 1}   -2.42{col 52}{space 3}0.016{col 60}{space 4}-21.23832{col 73}{space 3}-2.207218
{txt}{space 13}2011  {c |}{col 20}{res}{space 2}-12.65463{col 32}{space 2} 4.178352{col 43}{space 1}   -3.03{col 52}{space 3}0.003{col 60}{space 4}-20.86198{col 73}{space 3}-4.447284
{txt}{space 13}2012  {c |}{col 20}{res}{space 2}-23.12413{col 32}{space 2} 4.163961{col 43}{space 1}   -5.55{col 52}{space 3}0.000{col 60}{space 4}-31.30321{col 73}{space 3}-14.94505
{txt}{space 13}2013  {c |}{col 20}{res}{space 2}-23.35627{col 32}{space 2} 4.283326{col 43}{space 1}   -5.45{col 52}{space 3}0.000{col 60}{space 4}-31.76981{col 73}{space 3}-14.94272
{txt}{space 13}2014  {c |}{col 20}{res}{space 2}-22.67397{col 32}{space 2} 4.255915{col 43}{space 1}   -5.33{col 52}{space 3}0.000{col 60}{space 4}-31.03368{col 73}{space 3}-14.31427
{txt}{space 13}2015  {c |}{col 20}{res}{space 2}-21.68956{col 32}{space 2}  4.43314{col 43}{space 1}   -4.89{col 52}{space 3}0.000{col 60}{space 4}-30.39738{col 73}{space 3}-12.98174
{txt}{space 13}2016  {c |}{col 20}{res}{space 2}-25.59977{col 32}{space 2} 4.573117{col 43}{space 1}   -5.60{col 52}{space 3}0.000{col 60}{space 4}-34.58254{col 73}{space 3}  -16.617
{txt}{space 18} {c |}
{space 13}_cons {c |}{col 20}{res}{space 2}-414.4083{col 32}{space 2} 339.7209{col 43}{space 1}   -1.22{col 52}{space 3}0.223{col 60}{space 4}-1081.707{col 73}{space 3} 252.8902
{txt}{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
           sigma_u {c |} {res} 76.687107
           {txt}sigma_e {c |} {res} 50.048689
               {txt}rho {c |} {res} .70129551{txt}   (fraction of variance due to u_i)
{hline 19}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) replace
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     3,715
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0321{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0253{col 63}{txt}avg{col 67}={col 69}{res}       6.5
{txt}     overall = {res}0.0280{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}567{txt}){col 67}={col 70}{res}    15.43
{txt}corr(u_i, Xb){col 16}= {res}-0.0190{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 84:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 19}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 20}{c |}{col 32}    Robust
{col 1}fed_act_yr_city_~c{col 20}{c |}      Coef.{col 32}   Std. Err.{col 44}      t{col 52}   P>|t|{col 60}     [95% Con{col 73}f. Interval]
{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_party {c |}{col 20}{res}{space 2}-.8034961{col 32}{space 2} 1.758851{col 43}{space 1}   -0.46{col 52}{space 3}0.648{col 60}{space 4}-4.258156{col 73}{space 3} 2.651164
{txt}{space 8}ln_tot_pop {c |}{col 20}{res}{space 2} 4.863187{col 32}{space 2} 17.46703{col 43}{space 1}    0.28{col 52}{space 3}0.781{col 60}{space 4}-29.44479{col 73}{space 3} 39.17117
{txt}{space 6}ln_income_pc {c |}{col 20}{res}{space 2}-19.59876{col 32}{space 2} 38.45131{col 43}{space 1}   -0.51{col 52}{space 3}0.610{col 60}{space 4}-95.12317{col 73}{space 3} 55.92564
{txt}{space 10}pov_rate {c |}{col 20}{res}{space 2}-66.72262{col 32}{space 2} 102.0967{col 43}{space 1}   -0.65{col 52}{space 3}0.514{col 60}{space 4}-267.2565{col 73}{space 3} 133.8113
{txt}{space 18} {c |}
{space 14}year {c |}
{space 13}2006  {c |}{col 20}{res}{space 2} -1.13652{col 32}{space 2} 1.784153{col 43}{space 1}   -0.64{col 52}{space 3}0.524{col 60}{space 4}-4.640876{col 73}{space 3} 2.367836
{txt}{space 13}2007  {c |}{col 20}{res}{space 2} 2.089144{col 32}{space 2} 2.559636{col 43}{space 1}    0.82{col 52}{space 3}0.415{col 60}{space 4}-2.938381{col 73}{space 3} 7.116669
{txt}{space 13}2008  {c |}{col 20}{res}{space 2} 22.14831{col 32}{space 2} 3.993474{col 43}{space 1}    5.55{col 52}{space 3}0.000{col 60}{space 4}  14.3045{col 73}{space 3} 29.99212
{txt}{space 13}2017  {c |}{col 20}{res}{space 2} 2.083995{col 32}{space 2} 8.791398{col 43}{space 1}    0.24{col 52}{space 3}0.813{col 60}{space 4}-15.18369{col 73}{space 3} 19.35168
{txt}{space 13}2018  {c |}{col 20}{res}{space 2}  7.20659{col 32}{space 2} 10.35238{col 43}{space 1}    0.70{col 52}{space 3}0.487{col 60}{space 4} -13.1271{col 73}{space 3} 27.54028
{txt}{space 13}2019  {c |}{col 20}{res}{space 2} 17.54276{col 32}{space 2} 11.77581{col 43}{space 1}    1.49{col 52}{space 3}0.137{col 60}{space 4}-5.586776{col 73}{space 3}  40.6723
{txt}{space 13}2020  {c |}{col 20}{res}{space 2} 18.57766{col 32}{space 2}  15.7884{col 43}{space 1}    1.18{col 52}{space 3}0.240{col 60}{space 4}-12.43323{col 73}{space 3} 49.58854
{txt}{space 18} {c |}
{space 13}_cons {c |}{col 20}{res}{space 2} 155.1467{col 32}{space 2} 508.8466{col 43}{space 1}    0.30{col 52}{space 3}0.761{col 60}{space 4}-844.3078{col 73}{space 3} 1154.601
{txt}{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
           sigma_u {c |} {res} 24.688625
           {txt}sigma_e {c |} {res} 46.407465
               {txt}rho {c |} {res} .22058931{txt}   (fraction of variance due to u_i)
{hline 19}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. 
. xtreg fed_act_yr_city_2012_pc i.strong_mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     4,307
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       555

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0322{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.0320{col 63}{txt}avg{col 67}={col 69}{res}       7.8
{txt}     overall = {res}0.0099{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}554{txt}){col 67}={col 70}{res}    12.01
{txt}corr(u_i, Xb){col 16}= {res}-0.9373{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:555} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  fed_act_yr_city_2012_pc{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.strong_mayor_pres_party {c |}{col 27}{res}{space 2} 4.439117{col 39}{space 2} 2.492895{col 50}{space 1}    1.78{col 59}{space 3}0.076{col 67}{space 4}-.4575657{col 80}{space 3} 9.335799
{txt}{space 15}ln_tot_pop {c |}{col 27}{res}{space 2} 98.25572{col 39}{space 2} 39.72209{col 50}{space 1}    2.47{col 59}{space 3}0.014{col 67}{space 4}  20.2314{col 80}{space 3}   176.28
{txt}{space 13}ln_income_pc {c |}{col 27}{res}{space 2}-67.45355{col 39}{space 2} 51.00669{col 50}{space 1}   -1.32{col 59}{space 3}0.187{col 67}{space 4}-167.6437{col 80}{space 3} 32.73661
{txt}{space 17}pov_rate {c |}{col 27}{res}{space 2}-88.49972{col 39}{space 2} 227.7401{col 50}{space 1}   -0.39{col 59}{space 3}0.698{col 67}{space 4}-535.8393{col 80}{space 3} 358.8399
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2010  {c |}{col 27}{res}{space 2}-11.72484{col 39}{space 2} 4.846745{col 50}{space 1}   -2.42{col 59}{space 3}0.016{col 67}{space 4}-21.24508{col 80}{space 3}-2.204595
{txt}{space 20}2011  {c |}{col 27}{res}{space 2}-12.70341{col 39}{space 2} 4.180003{col 50}{space 1}   -3.04{col 59}{space 3}0.002{col 67}{space 4}-20.91401{col 80}{space 3}-4.492821
{txt}{space 20}2012  {c |}{col 27}{res}{space 2}-23.14179{col 39}{space 2} 4.163334{col 50}{space 1}   -5.56{col 59}{space 3}0.000{col 67}{space 4}-31.31964{col 80}{space 3}-14.96394
{txt}{space 20}2013  {c |}{col 27}{res}{space 2}-23.37562{col 39}{space 2}  4.27902{col 50}{space 1}   -5.46{col 59}{space 3}0.000{col 67}{space 4}-31.78071{col 80}{space 3}-14.97054
{txt}{space 20}2014  {c |}{col 27}{res}{space 2}-22.69493{col 39}{space 2} 4.245322{col 50}{space 1}   -5.35{col 59}{space 3}0.000{col 67}{space 4}-31.03383{col 80}{space 3}-14.35604
{txt}{space 20}2015  {c |}{col 27}{res}{space 2}-21.69132{col 39}{space 2} 4.423952{col 50}{space 1}   -4.90{col 59}{space 3}0.000{col 67}{space 4}-30.38109{col 80}{space 3}-13.00155
{txt}{space 20}2016  {c |}{col 27}{res}{space 2}-25.61582{col 39}{space 2} 4.567021{col 50}{space 1}   -5.61{col 59}{space 3}0.000{col 67}{space 4}-34.58661{col 80}{space 3}-16.64502
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2}-419.5947{col 39}{space 2} 338.4845{col 50}{space 1}   -1.24{col 59}{space 3}0.216{col 67}{space 4}-1084.465{col 80}{space 3} 245.2753
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 76.937993
                  {txt}sigma_e {c |} {res} 50.040594
                      {txt}rho {c |} {res}  .7027297{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.strong_mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     3,715
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0322{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0242{col 63}{txt}avg{col 67}={col 69}{res}       6.5
{txt}     overall = {res}0.0276{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}567{txt}){col 67}={col 70}{res}    15.59
{txt}corr(u_i, Xb){col 16}= {res}-0.0210{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  fed_act_yr_city_2012_pc{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.strong_mayor_pres_party {c |}{col 27}{res}{space 2}-1.955489{col 39}{space 2}   2.1085{col 50}{space 1}   -0.93{col 59}{space 3}0.354{col 67}{space 4}-6.096914{col 80}{space 3} 2.185936
{txt}{space 15}ln_tot_pop {c |}{col 27}{res}{space 2} 4.749929{col 39}{space 2} 17.41767{col 50}{space 1}    0.27{col 59}{space 3}0.785{col 67}{space 4} -29.4611{col 80}{space 3} 38.96096
{txt}{space 13}ln_income_pc {c |}{col 27}{res}{space 2}-19.58968{col 39}{space 2}  38.4202{col 50}{space 1}   -0.51{col 59}{space 3}0.610{col 67}{space 4}-95.05297{col 80}{space 3}  55.8736
{txt}{space 17}pov_rate {c |}{col 27}{res}{space 2}-65.75999{col 39}{space 2} 102.1303{col 50}{space 1}   -0.64{col 59}{space 3}0.520{col 67}{space 4}-266.3598{col 80}{space 3} 134.8398
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2006  {c |}{col 27}{res}{space 2}-1.144704{col 39}{space 2} 1.784717{col 50}{space 1}   -0.64{col 59}{space 3}0.522{col 67}{space 4}-4.650169{col 80}{space 3}  2.36076
{txt}{space 20}2007  {c |}{col 27}{res}{space 2} 2.072386{col 39}{space 2} 2.562189{col 50}{space 1}    0.81{col 59}{space 3}0.419{col 67}{space 4}-2.960154{col 80}{space 3} 7.104926
{txt}{space 20}2008  {c |}{col 27}{res}{space 2} 22.15678{col 39}{space 2} 3.990657{col 50}{space 1}    5.55{col 59}{space 3}0.000{col 67}{space 4}  14.3185{col 80}{space 3} 29.99505
{txt}{space 20}2017  {c |}{col 27}{res}{space 2} 2.078901{col 39}{space 2} 8.783752{col 50}{space 1}    0.24{col 59}{space 3}0.813{col 67}{space 4}-15.17376{col 80}{space 3} 19.33157
{txt}{space 20}2018  {c |}{col 27}{res}{space 2} 7.204877{col 39}{space 2} 10.34123{col 50}{space 1}    0.70{col 59}{space 3}0.486{col 67}{space 4}-13.10693{col 80}{space 3} 27.51668
{txt}{space 20}2019  {c |}{col 27}{res}{space 2} 17.54143{col 39}{space 2} 11.76141{col 50}{space 1}    1.49{col 59}{space 3}0.136{col 67}{space 4}-5.559816{col 80}{space 3} 40.64267
{txt}{space 20}2020  {c |}{col 27}{res}{space 2} 18.56545{col 39}{space 2} 15.76915{col 50}{space 1}    1.18{col 59}{space 3}0.240{col 67}{space 4}-12.40764{col 80}{space 3} 49.53854
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2} 156.2806{col 39}{space 2} 507.9476{col 50}{space 1}    0.31{col 59}{space 3}0.758{col 67}{space 4}-841.4081{col 80}{space 3} 1153.969
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 24.705698
                  {txt}sigma_e {c |} {res} 46.406113
                      {txt}rho {c |} {res} .22083714{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. 
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     4,307
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       555

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0329{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.0325{col 63}{txt}avg{col 67}={col 69}{res}       7.8
{txt}     overall = {res}0.0102{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}554{txt}){col 67}={col 70}{res}    12.12
{txt}corr(u_i, Xb){col 16}= {res}-0.9334{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 90:(Std. Err. adjusted for {res:555} clusters in geo_fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 26}{c |}{col 38}    Robust
{col 1} fed_act_yr_city_2012_pc{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_gover_party {c |}{col 26}{res}{space 2} 5.689095{col 38}{space 2} 2.185448{col 49}{space 1}    2.60{col 58}{space 3}0.009{col 66}{space 4} 1.396318{col 79}{space 3} 9.981872
{txt}{space 14}ln_tot_pop {c |}{col 26}{res}{space 2} 95.54353{col 38}{space 2} 39.98646{col 49}{space 1}    2.39{col 58}{space 3}0.017{col 66}{space 4} 16.99992{col 79}{space 3} 174.0871
{txt}{space 12}ln_income_pc {c |}{col 26}{res}{space 2} -67.0076{col 38}{space 2} 51.09443{col 49}{space 1}   -1.31{col 58}{space 3}0.190{col 66}{space 4}-167.3701{col 79}{space 3}  33.3549
{txt}{space 16}pov_rate {c |}{col 26}{res}{space 2}-88.04519{col 38}{space 2} 227.9699{col 49}{space 1}   -0.39{col 58}{space 3}0.699{col 66}{space 4}-535.8363{col 79}{space 3} 359.7459
{txt}{space 24} {c |}
{space 20}year {c |}
{space 19}2010  {c |}{col 26}{res}{space 2}-11.57763{col 38}{space 2} 4.852949{col 49}{space 1}   -2.39{col 58}{space 3}0.017{col 66}{space 4}-21.11006{col 79}{space 3}-2.045203
{txt}{space 19}2011  {c |}{col 26}{res}{space 2} -12.4531{col 38}{space 2}   4.1764{col 49}{space 1}   -2.98{col 58}{space 3}0.003{col 66}{space 4}-20.65662{col 79}{space 3}-4.249584
{txt}{space 19}2012  {c |}{col 26}{res}{space 2}-22.92036{col 38}{space 2} 4.153558{col 49}{space 1}   -5.52{col 58}{space 3}0.000{col 66}{space 4}-31.07901{col 79}{space 3}-14.76171
{txt}{space 19}2013  {c |}{col 26}{res}{space 2}-23.07633{col 38}{space 2} 4.260726{col 49}{space 1}   -5.42{col 58}{space 3}0.000{col 66}{space 4}-31.44548{col 79}{space 3}-14.70717
{txt}{space 19}2014  {c |}{col 26}{res}{space 2}-22.46001{col 38}{space 2} 4.226396{col 49}{space 1}   -5.31{col 58}{space 3}0.000{col 66}{space 4}-30.76173{col 79}{space 3}-14.15829
{txt}{space 19}2015  {c |}{col 26}{res}{space 2}-21.18386{col 38}{space 2} 4.405323{col 49}{space 1}   -4.81{col 58}{space 3}0.000{col 66}{space 4}-29.83704{col 79}{space 3}-12.53068
{txt}{space 19}2016  {c |}{col 26}{res}{space 2}-25.09455{col 38}{space 2} 4.529392{col 49}{space 1}   -5.54{col 58}{space 3}0.000{col 66}{space 4}-33.99143{col 79}{space 3}-16.19766
{txt}{space 24} {c |}
{space 19}_cons {c |}{col 26}{res}{space 2}-393.2276{col 38}{space 2} 338.1249{col 49}{space 1}   -1.16{col 58}{space 3}0.245{col 66}{space 4}-1057.391{col 79}{space 3}  270.936
{txt}{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                 sigma_u {c |} {res} 74.769893
                 {txt}sigma_e {c |} {res} 50.022781
                     {txt}rho {c |} {res} .69080247{txt}   (fraction of variance due to u_i)
{hline 25}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     3,715
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0323{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0128{col 63}{txt}avg{col 67}={col 69}{res}       6.5
{txt}     overall = {res}0.0237{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}567{txt}){col 67}={col 70}{res}    15.14
{txt}corr(u_i, Xb){col 16}= {res}-0.0434{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 90:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 26}{c |}{col 38}    Robust
{col 1} fed_act_yr_city_2012_pc{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_gover_party {c |}{col 26}{res}{space 2} 2.761377{col 38}{space 2} 1.584644{col 49}{space 1}    1.74{col 58}{space 3}0.082{col 66}{space 4}-.3511118{col 79}{space 3} 5.873867
{txt}{space 14}ln_tot_pop {c |}{col 26}{res}{space 2} 4.084163{col 38}{space 2} 17.43094{col 49}{space 1}    0.23{col 58}{space 3}0.815{col 66}{space 4}-30.15293{col 79}{space 3} 38.32126
{txt}{space 12}ln_income_pc {c |}{col 26}{res}{space 2} -19.7899{col 38}{space 2} 38.43887{col 49}{space 1}   -0.51{col 58}{space 3}0.607{col 66}{space 4}-95.28986{col 79}{space 3} 55.71007
{txt}{space 16}pov_rate {c |}{col 26}{res}{space 2} -59.7539{col 38}{space 2} 102.0823{col 49}{space 1}   -0.59{col 58}{space 3}0.559{col 66}{space 4}-260.2595{col 79}{space 3} 140.7517
{txt}{space 24} {c |}
{space 20}year {c |}
{space 19}2006  {c |}{col 26}{res}{space 2}-1.178955{col 38}{space 2} 1.781693{col 49}{space 1}   -0.66{col 58}{space 3}0.508{col 66}{space 4} -4.67848{col 79}{space 3}  2.32057
{txt}{space 19}2007  {c |}{col 26}{res}{space 2} 2.084291{col 38}{space 2} 2.559464{col 49}{space 1}    0.81{col 58}{space 3}0.416{col 66}{space 4}-2.942897{col 79}{space 3} 7.111479
{txt}{space 19}2008  {c |}{col 26}{res}{space 2} 22.18769{col 38}{space 2} 3.992309{col 49}{space 1}    5.56{col 58}{space 3}0.000{col 66}{space 4} 14.34617{col 79}{space 3} 30.02921
{txt}{space 19}2017  {c |}{col 26}{res}{space 2} 2.099604{col 38}{space 2} 8.778519{col 49}{space 1}    0.24{col 58}{space 3}0.811{col 66}{space 4}-15.14278{col 79}{space 3} 19.34199
{txt}{space 19}2018  {c |}{col 26}{res}{space 2} 7.266643{col 38}{space 2} 10.33956{col 49}{space 1}    0.70{col 58}{space 3}0.482{col 66}{space 4}-13.04187{col 79}{space 3} 27.57516
{txt}{space 19}2019  {c |}{col 26}{res}{space 2}  17.7791{col 38}{space 2} 11.78207{col 49}{space 1}    1.51{col 58}{space 3}0.132{col 66}{space 4} -5.36273{col 79}{space 3} 40.92092
{txt}{space 19}2020  {c |}{col 26}{res}{space 2} 18.88803{col 38}{space 2} 15.79638{col 49}{space 1}    1.20{col 58}{space 3}0.232{col 66}{space 4}-12.13854{col 79}{space 3} 49.91459
{txt}{space 24} {c |}
{space 19}_cons {c |}{col 26}{res}{space 2} 164.7328{col 38}{space 2} 508.3436{col 49}{space 1}    0.32{col 58}{space 3}0.746{col 66}{space 4}-833.7336{col 79}{space 3} 1163.199
{txt}{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                 sigma_u {c |} {res} 24.907888
                 {txt}sigma_e {c |} {res} 46.402246
                     {txt}rho {c |} {res} .22368377{txt}   (fraction of variance due to u_i)
{hline 25}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. 
. xtreg fed_act_yr_city_2012_pc i.str_mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     4,307
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       555

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0325{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.0321{col 63}{txt}avg{col 67}={col 69}{res}       7.8
{txt}     overall = {res}0.0101{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}554{txt}){col 67}={col 70}{res}    12.02
{txt}corr(u_i, Xb){col 16}= {res}-0.9317{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 94:(Std. Err. adjusted for {res:555} clusters in geo_fips)}
{hline 29}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 30}{c |}{col 42}    Robust
{col 1}     fed_act_yr_city_2012_pc{col 30}{c |}      Coef.{col 42}   Std. Err.{col 54}      t{col 62}   P>|t|{col 70}     [95% Con{col 83}f. Interval]
{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.str_mayor_pres_gover_party {c |}{col 30}{res}{space 2} 6.311732{col 42}{space 2}  3.16698{col 53}{space 1}    1.99{col 62}{space 3}0.047{col 70}{space 4} .0909739{col 83}{space 3} 12.53249
{txt}{space 18}ln_tot_pop {c |}{col 30}{res}{space 2} 94.12239{col 42}{space 2}  39.9961{col 53}{space 1}    2.35{col 62}{space 3}0.019{col 70}{space 4} 15.55984{col 83}{space 3} 172.6849
{txt}{space 16}ln_income_pc {c |}{col 30}{res}{space 2}-67.17589{col 42}{space 2} 51.06466{col 53}{space 1}   -1.32{col 62}{space 3}0.189{col 70}{space 4}-167.4799{col 83}{space 3} 33.12815
{txt}{space 20}pov_rate {c |}{col 30}{res}{space 2}-90.84078{col 42}{space 2} 227.4993{col 53}{space 1}   -0.40{col 62}{space 3}0.690{col 70}{space 4}-537.7075{col 83}{space 3}  356.026
{txt}{space 28} {c |}
{space 24}year {c |}
{space 23}2010  {c |}{col 30}{res}{space 2}-11.63281{col 42}{space 2} 4.853726{col 53}{space 1}   -2.40{col 62}{space 3}0.017{col 70}{space 4}-21.16677{col 83}{space 3}-2.098858
{txt}{space 23}2011  {c |}{col 30}{res}{space 2}-12.64812{col 42}{space 2} 4.175246{col 53}{space 1}   -3.03{col 62}{space 3}0.003{col 70}{space 4}-20.84936{col 83}{space 3}-4.446868
{txt}{space 23}2012  {c |}{col 30}{res}{space 2} -23.0214{col 42}{space 2} 4.150437{col 53}{space 1}   -5.55{col 62}{space 3}0.000{col 70}{space 4}-31.17391{col 83}{space 3}-14.86888
{txt}{space 23}2013  {c |}{col 30}{res}{space 2} -23.2358{col 42}{space 2} 4.258366{col 53}{space 1}   -5.46{col 62}{space 3}0.000{col 70}{space 4}-31.60032{col 83}{space 3}-14.87128
{txt}{space 23}2014  {c |}{col 30}{res}{space 2}-22.52852{col 42}{space 2} 4.218756{col 53}{space 1}   -5.34{col 62}{space 3}0.000{col 70}{space 4}-30.81523{col 83}{space 3} -14.2418
{txt}{space 23}2015  {c |}{col 30}{res}{space 2}-21.22045{col 42}{space 2} 4.378192{col 53}{space 1}   -4.85{col 62}{space 3}0.000{col 70}{space 4}-29.82033{col 83}{space 3}-12.62056
{txt}{space 23}2016  {c |}{col 30}{res}{space 2}-25.15907{col 42}{space 2} 4.494857{col 53}{space 1}   -5.60{col 62}{space 3}0.000{col 70}{space 4}-33.98812{col 83}{space 3}-16.33002
{txt}{space 28} {c |}
{space 23}_cons {c |}{col 30}{res}{space 2}-373.9623{col 42}{space 2} 330.0944{col 53}{space 1}   -1.13{col 62}{space 3}0.258{col 70}{space 4}-1022.352{col 83}{space 3} 274.4274
{txt}{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                     sigma_u {c |} {res} 73.855711
                     {txt}sigma_e {c |} {res} 50.032824
                         {txt}rho {c |} {res} .68543612{txt}   (fraction of variance due to u_i)
{hline 29}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.str_mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     3,715
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0321{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0194{col 63}{txt}avg{col 67}={col 69}{res}       6.5
{txt}     overall = {res}0.0261{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}567{txt}){col 67}={col 70}{res}    15.30
{txt}corr(u_i, Xb){col 16}= {res}-0.0273{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 94:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 29}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 30}{c |}{col 42}    Robust
{col 1}     fed_act_yr_city_2012_pc{col 30}{c |}      Coef.{col 42}   Std. Err.{col 54}      t{col 62}   P>|t|{col 70}     [95% Con{col 83}f. Interval]
{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.str_mayor_pres_gover_party {c |}{col 30}{res}{space 2} 1.198693{col 42}{space 2} 2.543587{col 53}{space 1}    0.47{col 62}{space 3}0.638{col 70}{space 4}-3.797309{col 83}{space 3} 6.194696
{txt}{space 18}ln_tot_pop {c |}{col 30}{res}{space 2} 4.574228{col 42}{space 2} 17.41342{col 53}{space 1}    0.26{col 62}{space 3}0.793{col 70}{space 4}-29.62845{col 83}{space 3}  38.7769
{txt}{space 16}ln_income_pc {c |}{col 30}{res}{space 2}-19.67275{col 42}{space 2} 38.42837{col 53}{space 1}   -0.51{col 62}{space 3}0.609{col 70}{space 4} -95.1521{col 83}{space 3}  55.8066
{txt}{space 20}pov_rate {c |}{col 30}{res}{space 2}-65.78976{col 42}{space 2} 102.1143{col 53}{space 1}   -0.64{col 62}{space 3}0.520{col 70}{space 4}-266.3583{col 83}{space 3} 134.7788
{txt}{space 28} {c |}
{space 24}year {c |}
{space 23}2006  {c |}{col 30}{res}{space 2}-1.147753{col 42}{space 2} 1.784342{col 53}{space 1}   -0.64{col 62}{space 3}0.520{col 70}{space 4}-4.652481{col 83}{space 3} 2.356975
{txt}{space 23}2007  {c |}{col 30}{res}{space 2} 2.070988{col 42}{space 2} 2.560897{col 53}{space 1}    0.81{col 62}{space 3}0.419{col 70}{space 4}-2.959015{col 83}{space 3}  7.10099
{txt}{space 23}2008  {c |}{col 30}{res}{space 2} 22.14948{col 42}{space 2} 3.989719{col 53}{space 1}    5.55{col 62}{space 3}0.000{col 70}{space 4} 14.31305{col 83}{space 3} 29.98592
{txt}{space 23}2017  {c |}{col 30}{res}{space 2} 2.094547{col 42}{space 2} 8.782345{col 53}{space 1}    0.24{col 62}{space 3}0.812{col 70}{space 4}-15.15535{col 83}{space 3} 19.34445
{txt}{space 23}2018  {c |}{col 30}{res}{space 2} 7.231262{col 42}{space 2} 10.34009{col 53}{space 1}    0.70{col 62}{space 3}0.485{col 70}{space 4}-13.07829{col 83}{space 3} 27.54082
{txt}{space 23}2019  {c |}{col 30}{res}{space 2} 17.60148{col 42}{space 2} 11.75928{col 53}{space 1}    1.50{col 62}{space 3}0.135{col 70}{space 4}-5.495582{col 83}{space 3} 40.69855
{txt}{space 23}2020  {c |}{col 30}{res}{space 2} 18.65856{col 42}{space 2} 15.76196{col 53}{space 1}    1.18{col 62}{space 3}0.237{col 70}{space 4} -12.3004{col 83}{space 3} 49.61752
{txt}{space 28} {c |}
{space 23}_cons {c |}{col 30}{res}{space 2} 158.8101{col 42}{space 2} 507.7984{col 53}{space 1}    0.31{col 62}{space 3}0.755{col 70}{space 4}-838.5856{col 83}{space 3} 1156.206
{txt}{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                     sigma_u {c |} {res} 24.778716
                     {txt}sigma_e {c |} {res} 46.407427
                         {txt}rho {c |} {res} .22184463{txt}   (fraction of variance due to u_i)
{hline 29}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_pc_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $), Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_pc_presparty.tex"'"':R1_final_fed_act_con_pc_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_pc_presparty.txt""':seeout}

{com}. 
. 
. 
. 
. ** Addition **
. ** Table B.6 **
. 
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_party##i.pres_dem c.ln_tot_pop#i.pres_dem c.ln_income_pc#i.pres_dem c.pov_rate#i.pres_dem i.year, fe vce(cluster geo_fips)
{p 0 6 2}{txt}note: 2016.year omitted because of collinearity{p_end}
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0280{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0546{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0206{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}23{txt},{res}567{txt}){col 67}={col 70}{res}    11.76
{txt}corr(u_i, Xb){col 16}= {res}-0.5166{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  fed_act_yr_city_2012_pc{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}1.mayor_pres_party {c |}{col 27}{res}{space 2} .2024798{col 39}{space 2} 2.568428{col 50}{space 1}    0.08{col 59}{space 3}0.937{col 67}{space 4}-4.842314{col 80}{space 3} 5.247274
{txt}{space 15}1.pres_dem {c |}{col 27}{res}{space 2} 77.03654{col 39}{space 2} 71.62367{col 50}{space 1}    1.08{col 59}{space 3}0.283{col 67}{space 4}-63.64357{col 80}{space 3} 217.7166
{txt}{space 25} {c |}
mayor_pres_party#pres_dem {c |}
{space 21}1 1  {c |}{col 27}{res}{space 2} .6014564{col 39}{space 2} 4.914139{col 50}{space 1}    0.12{col 59}{space 3}0.903{col 67}{space 4}-9.050683{col 80}{space 3}  10.2536
{txt}{space 25} {c |}
{space 4}pres_dem#c.ln_tot_pop {c |}
{space 23}0  {c |}{col 27}{res}{space 2} 26.19946{col 39}{space 2} 16.59357{col 50}{space 1}    1.58{col 59}{space 3}0.115{col 67}{space 4}-6.392917{col 80}{space 3} 58.79184
{txt}{space 23}1  {c |}{col 27}{res}{space 2} 23.67004{col 39}{space 2} 16.07123{col 50}{space 1}    1.47{col 59}{space 3}0.141{col 67}{space 4}-7.896371{col 80}{space 3} 55.23645
{txt}{space 25} {c |}
{space 2}pres_dem#c.ln_income_pc {c |}
{space 23}0  {c |}{col 27}{res}{space 2}-17.58096{col 39}{space 2} 24.74393{col 50}{space 1}   -0.71{col 59}{space 3}0.478{col 67}{space 4}-66.18191{col 80}{space 3}    31.02
{txt}{space 23}1  {c |}{col 27}{res}{space 2}-22.21927{col 39}{space 2} 27.34906{col 50}{space 1}   -0.81{col 59}{space 3}0.417{col 67}{space 4}-75.93711{col 80}{space 3} 31.49858
{txt}{space 25} {c |}
{space 6}pres_dem#c.pov_rate {c |}
{space 23}0  {c |}{col 27}{res}{space 2}-28.30428{col 39}{space 2} 81.87103{col 50}{space 1}   -0.35{col 59}{space 3}0.730{col 67}{space 4}-189.1118{col 80}{space 3} 132.5032
{txt}{space 23}1  {c |}{col 27}{res}{space 2}-40.88986{col 39}{space 2} 91.61722{col 50}{space 1}   -0.45{col 59}{space 3}0.656{col 67}{space 4}-220.8404{col 80}{space 3} 139.0607
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2006  {c |}{col 27}{res}{space 2}-1.214174{col 39}{space 2} 1.786406{col 50}{space 1}   -0.68{col 59}{space 3}0.497{col 67}{space 4}-4.722956{col 80}{space 3} 2.294607
{txt}{space 20}2007  {c |}{col 27}{res}{space 2}  1.71538{col 39}{space 2} 2.013983{col 50}{space 1}    0.85{col 59}{space 3}0.395{col 67}{space 4}-2.240399{col 80}{space 3} 5.671159
{txt}{space 20}2008  {c |}{col 27}{res}{space 2} 21.63149{col 39}{space 2} 2.859101{col 50}{space 1}    7.57{col 59}{space 3}0.000{col 67}{space 4} 16.01577{col 80}{space 3} 27.24722
{txt}{space 20}2009  {c |}{col 27}{res}{space 2} 24.82882{col 39}{space 2} 5.828878{col 50}{space 1}    4.26{col 59}{space 3}0.000{col 67}{space 4}    13.38{col 80}{space 3} 36.27765
{txt}{space 20}2010  {c |}{col 27}{res}{space 2} 13.25806{col 39}{space 2}  3.17187{col 50}{space 1}    4.18{col 59}{space 3}0.000{col 67}{space 4} 7.028013{col 80}{space 3} 19.48811
{txt}{space 20}2011  {c |}{col 27}{res}{space 2} 12.06281{col 39}{space 2} 2.381183{col 50}{space 1}    5.07{col 59}{space 3}0.000{col 67}{space 4} 7.385794{col 80}{space 3} 16.73983
{txt}{space 20}2012  {c |}{col 27}{res}{space 2} 1.997768{col 39}{space 2} 1.979983{col 50}{space 1}    1.01{col 59}{space 3}0.313{col 67}{space 4}-1.891229{col 80}{space 3} 5.886764
{txt}{space 20}2013  {c |}{col 27}{res}{space 2} 2.332243{col 39}{space 2} 1.655051{col 50}{space 1}    1.41{col 59}{space 3}0.159{col 67}{space 4}-.9185367{col 80}{space 3} 5.583023
{txt}{space 20}2014  {c |}{col 27}{res}{space 2} 3.242334{col 39}{space 2} 1.757653{col 50}{space 1}    1.84{col 59}{space 3}0.066{col 67}{space 4}-.2099715{col 80}{space 3}  6.69464
{txt}{space 20}2015  {c |}{col 27}{res}{space 2} 4.574088{col 39}{space 2}  1.50181{col 50}{space 1}    3.05{col 59}{space 3}0.002{col 67}{space 4} 1.624299{col 80}{space 3} 7.523878
{txt}{space 20}2016  {c |}{col 27}{res}{space 2}        0{col 39}{txt}  (omitted)
{space 20}2017  {c |}{col 27}{res}{space 2} -.789952{col 39}{space 2} 5.453746{col 50}{space 1}   -0.14{col 59}{space 3}0.885{col 67}{space 4}-11.50196{col 80}{space 3} 9.922059
{txt}{space 20}2018  {c |}{col 27}{res}{space 2} 4.247184{col 39}{space 2} 6.423813{col 50}{space 1}    0.66{col 59}{space 3}0.509{col 67}{space 4} -8.37019{col 80}{space 3} 16.86456
{txt}{space 20}2019  {c |}{col 27}{res}{space 2} 14.54824{col 39}{space 2} 7.258262{col 50}{space 1}    2.00{col 59}{space 3}0.046{col 67}{space 4} .2918773{col 80}{space 3}  28.8046
{txt}{space 20}2020  {c |}{col 27}{res}{space 2} 15.54866{col 39}{space 2} 10.61683{col 50}{space 1}    1.46{col 59}{space 3}0.144{col 67}{space 4}-5.304461{col 80}{space 3} 36.40177
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2}-116.5825{col 39}{space 2} 350.3754{col 50}{space 1}   -0.33{col 59}{space 3}0.739{col 67}{space 4}-804.7747{col 80}{space 3} 571.6096
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 25.325747
                  {txt}sigma_e {c |} {res} 48.834624
                      {txt}rho {c |} {res} .21194584{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_demdummy, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) replace
{txt}{stata `"shellout using `"R1_final_fed_act_con_demdummy.tex"'"':R1_final_fed_act_con_demdummy.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_demdummy.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.strong_mayor_pres_party##i.pres_dem c.ln_tot_pop#i.pres_dem c.ln_income_pc#i.pres_dem c.pov_rate#i.pres_dem i.year, fe vce(cluster geo_fips)
{p 0 6 2}{txt}note: 2016.year omitted because of collinearity{p_end}
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0290{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0573{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0219{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}23{txt},{res}567{txt}){col 67}={col 70}{res}    11.41
{txt}corr(u_i, Xb){col 16}= {res}-0.5073{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  fed_act_yr_city_2012_pc{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.strong_mayor_pres_party {c |}{col 27}{res}{space 2}-.3870452{col 39}{space 2} 1.873536{col 50}{space 1}   -0.21{col 59}{space 3}0.836{col 67}{space 4}-4.066963{col 80}{space 3} 3.292873
{txt}{space 15}1.pres_dem {c |}{col 27}{res}{space 2}  96.4721{col 39}{space 2} 71.08501{col 50}{space 1}    1.36{col 59}{space 3}0.175{col 67}{space 4}-43.14999{col 80}{space 3} 236.0942
{txt}{space 25} {c |}
{space 2}strong_mayor_pres_party#{c |}
{space 17}pres_dem {c |}
{space 21}1 1  {c |}{col 27}{res}{space 2}  7.12948{col 39}{space 2}  3.23335{col 50}{space 1}    2.20{col 59}{space 3}0.028{col 67}{space 4} .7786751{col 80}{space 3} 13.48029
{txt}{space 25} {c |}
{space 4}pres_dem#c.ln_tot_pop {c |}
{space 23}0  {c |}{col 27}{res}{space 2} 25.84575{col 39}{space 2} 16.85387{col 50}{space 1}    1.53{col 59}{space 3}0.126{col 67}{space 4}-7.257887{col 80}{space 3} 58.94938
{txt}{space 23}1  {c |}{col 27}{res}{space 2} 22.94091{col 39}{space 2} 16.32911{col 50}{space 1}    1.40{col 59}{space 3}0.161{col 67}{space 4} -9.13203{col 80}{space 3} 55.01385
{txt}{space 25} {c |}
{space 2}pres_dem#c.ln_income_pc {c |}
{space 23}0  {c |}{col 27}{res}{space 2}-16.54872{col 39}{space 2} 24.62315{col 50}{space 1}   -0.67{col 59}{space 3}0.502{col 67}{space 4}-64.91244{col 80}{space 3} 31.81501
{txt}{space 23}1  {c |}{col 27}{res}{space 2}-22.66644{col 39}{space 2} 27.15819{col 50}{space 1}   -0.83{col 59}{space 3}0.404{col 67}{space 4}-76.00938{col 80}{space 3}  30.6765
{txt}{space 25} {c |}
{space 6}pres_dem#c.pov_rate {c |}
{space 23}0  {c |}{col 27}{res}{space 2}-20.09809{col 39}{space 2} 81.02583{col 50}{space 1}   -0.25{col 59}{space 3}0.804{col 67}{space 4}-179.2455{col 80}{space 3} 139.0493
{txt}{space 23}1  {c |}{col 27}{res}{space 2}-48.00878{col 39}{space 2} 89.89865{col 50}{space 1}   -0.53{col 59}{space 3}0.594{col 67}{space 4}-224.5838{col 80}{space 3} 128.5663
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2006  {c |}{col 27}{res}{space 2}-1.215351{col 39}{space 2} 1.786628{col 50}{space 1}   -0.68{col 59}{space 3}0.497{col 67}{space 4}-4.724568{col 80}{space 3} 2.293866
{txt}{space 20}2007  {c |}{col 27}{res}{space 2} 1.680695{col 39}{space 2} 1.988843{col 50}{space 1}    0.85{col 59}{space 3}0.398{col 67}{space 4}-2.225706{col 80}{space 3} 5.587095
{txt}{space 20}2008  {c |}{col 27}{res}{space 2} 21.55925{col 39}{space 2} 2.840529{col 50}{space 1}    7.59{col 59}{space 3}0.000{col 67}{space 4} 15.98001{col 80}{space 3}  27.1385
{txt}{space 20}2009  {c |}{col 27}{res}{space 2} 24.50404{col 39}{space 2} 5.848813{col 50}{space 1}    4.19{col 59}{space 3}0.000{col 67}{space 4} 13.01606{col 80}{space 3} 35.99203
{txt}{space 20}2010  {c |}{col 27}{res}{space 2} 13.02842{col 39}{space 2} 3.156348{col 50}{space 1}    4.13{col 59}{space 3}0.000{col 67}{space 4} 6.828855{col 80}{space 3} 19.22798
{txt}{space 20}2011  {c |}{col 27}{res}{space 2} 11.84567{col 39}{space 2}  2.37733{col 50}{space 1}    4.98{col 59}{space 3}0.000{col 67}{space 4} 7.176222{col 80}{space 3} 16.51512
{txt}{space 20}2012  {c |}{col 27}{res}{space 2} 1.883892{col 39}{space 2} 1.980018{col 50}{space 1}    0.95{col 59}{space 3}0.342{col 67}{space 4}-2.005174{col 80}{space 3} 5.772957
{txt}{space 20}2013  {c |}{col 27}{res}{space 2} 2.270995{col 39}{space 2}  1.65987{col 50}{space 1}    1.37{col 59}{space 3}0.172{col 67}{space 4}-.9892505{col 80}{space 3}  5.53124
{txt}{space 20}2014  {c |}{col 27}{res}{space 2} 3.202708{col 39}{space 2} 1.760515{col 50}{space 1}    1.82{col 59}{space 3}0.069{col 67}{space 4}-.2552194{col 80}{space 3} 6.660635
{txt}{space 20}2015  {c |}{col 27}{res}{space 2} 4.590992{col 39}{space 2} 1.506312{col 50}{space 1}    3.05{col 59}{space 3}0.002{col 67}{space 4}  1.63236{col 80}{space 3} 7.549624
{txt}{space 20}2016  {c |}{col 27}{res}{space 2}        0{col 39}{txt}  (omitted)
{space 20}2017  {c |}{col 27}{res}{space 2}-1.022855{col 39}{space 2} 5.424048{col 50}{space 1}   -0.19{col 59}{space 3}0.850{col 67}{space 4}-11.67653{col 80}{space 3} 9.630825
{txt}{space 20}2018  {c |}{col 27}{res}{space 2} 3.999769{col 39}{space 2} 6.391435{col 50}{space 1}    0.63{col 59}{space 3}0.532{col 67}{space 4}-8.554012{col 80}{space 3} 16.55355
{txt}{space 20}2019  {c |}{col 27}{res}{space 2} 14.28681{col 39}{space 2} 7.213671{col 50}{space 1}    1.98{col 59}{space 3}0.048{col 67}{space 4} .1180296{col 80}{space 3} 28.45559
{txt}{space 20}2020  {c |}{col 27}{res}{space 2} 15.27788{col 39}{space 2} 10.57376{col 50}{space 1}    1.44{col 59}{space 3}0.149{col 67}{space 4}-5.490645{col 80}{space 3}  36.0464
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2}-123.3046{col 39}{space 2} 350.4445{col 50}{space 1}   -0.35{col 59}{space 3}0.725{col 67}{space 4}-811.6325{col 80}{space 3} 565.0233
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 25.135705
                  {txt}sigma_e {c |} {res} 48.809354
                      {txt}rho {c |} {res} .20961208{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_demdummy, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_demdummy.tex"'"':R1_final_fed_act_con_demdummy.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_demdummy.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.mayor_pres_gover_party##i.pres_dem c.ln_tot_pop#i.pres_dem c.ln_income_pc#i.pres_dem c.pov_rate#i.pres_dem i.year, fe vce(cluster geo_fips)
{p 0 6 2}{txt}note: 2016.year omitted because of collinearity{p_end}
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0291{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0576{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0229{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}23{txt},{res}567{txt}){col 67}={col 70}{res}    11.60
{txt}corr(u_i, Xb){col 16}= {res}-0.4630{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 97:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 32}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 33}{c |}{col 45}    Robust
{col 1}        fed_act_yr_city_2012_pc{col 33}{c |}      Coef.{col 45}   Std. Err.{col 57}      t{col 65}   P>|t|{col 73}     [95% Con{col 86}f. Interval]
{hline 32}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}1.mayor_pres_gover_party {c |}{col 33}{res}{space 2} 1.336163{col 45}{space 2} 1.791216{col 56}{space 1}    0.75{col 65}{space 3}0.456{col 73}{space 4}-2.182066{col 86}{space 3} 4.854393
{txt}{space 21}1.pres_dem {c |}{col 33}{res}{space 2} 89.38832{col 45}{space 2} 71.39087{col 56}{space 1}    1.25{col 65}{space 3}0.211{col 73}{space 4}-50.83454{col 86}{space 3} 229.6112
{txt}{space 31} {c |}
mayor_pres_gover_party#pres_dem {c |}
{space 27}1 1  {c |}{col 33}{res}{space 2} 4.668583{col 45}{space 2} 3.172322{col 56}{space 1}    1.47{col 65}{space 3}0.142{col 73}{space 4}-1.562355{col 86}{space 3} 10.89952
{txt}{space 31} {c |}
{space 10}pres_dem#c.ln_tot_pop {c |}
{space 29}0  {c |}{col 33}{res}{space 2} 24.08585{col 45}{space 2}  16.7761{col 56}{space 1}    1.44{col 65}{space 3}0.152{col 73}{space 4}-8.865049{col 86}{space 3} 57.03674
{txt}{space 29}1  {c |}{col 33}{res}{space 2} 21.43634{col 45}{space 2} 16.21277{col 56}{space 1}    1.32{col 65}{space 3}0.187{col 73}{space 4}-10.40807{col 86}{space 3} 53.28076
{txt}{space 31} {c |}
{space 8}pres_dem#c.ln_income_pc {c |}
{space 29}0  {c |}{col 33}{res}{space 2}-15.70727{col 45}{space 2} 24.74043{col 56}{space 1}   -0.63{col 65}{space 3}0.526{col 73}{space 4}-64.30136{col 86}{space 3} 32.88682
{txt}{space 29}1  {c |}{col 33}{res}{space 2}-21.45779{col 45}{space 2} 27.26991{col 56}{space 1}   -0.79{col 65}{space 3}0.432{col 73}{space 4}-75.02017{col 86}{space 3} 32.10458
{txt}{space 31} {c |}
{space 12}pres_dem#c.pov_rate {c |}
{space 29}0  {c |}{col 33}{res}{space 2}-20.47286{col 45}{space 2} 80.06082{col 56}{space 1}   -0.26{col 65}{space 3}0.798{col 73}{space 4}-177.7248{col 86}{space 3} 136.7791
{txt}{space 29}1  {c |}{col 33}{res}{space 2}-37.19951{col 45}{space 2}  90.8212{col 56}{space 1}   -0.41{col 65}{space 3}0.682{col 73}{space 4}-215.5866{col 86}{space 3} 141.1876
{txt}{space 31} {c |}
{space 27}year {c |}
{space 26}2006  {c |}{col 33}{res}{space 2}-1.233706{col 45}{space 2} 1.785448{col 56}{space 1}   -0.69{col 65}{space 3}0.490{col 73}{space 4}-4.740606{col 86}{space 3} 2.273193
{txt}{space 26}2007  {c |}{col 33}{res}{space 2} 1.653937{col 45}{space 2} 1.991474{col 56}{space 1}    0.83{col 65}{space 3}0.407{col 73}{space 4} -2.25763{col 86}{space 3} 5.565503
{txt}{space 26}2008  {c |}{col 33}{res}{space 2} 21.49122{col 45}{space 2}  2.85081{col 56}{space 1}    7.54{col 65}{space 3}0.000{col 73}{space 4} 15.89178{col 86}{space 3} 27.09066
{txt}{space 26}2009  {c |}{col 33}{res}{space 2} 24.28208{col 45}{space 2} 5.875426{col 56}{space 1}    4.13{col 65}{space 3}0.000{col 73}{space 4} 12.74182{col 86}{space 3} 35.82233
{txt}{space 26}2010  {c |}{col 33}{res}{space 2} 12.89317{col 45}{space 2} 3.139836{col 56}{space 1}    4.11{col 65}{space 3}0.000{col 73}{space 4} 6.726044{col 86}{space 3}  19.0603
{txt}{space 26}2011  {c |}{col 33}{res}{space 2} 11.76576{col 45}{space 2} 2.363143{col 56}{space 1}    4.98{col 65}{space 3}0.000{col 73}{space 4} 7.124181{col 86}{space 3} 16.40735
{txt}{space 26}2012  {c |}{col 33}{res}{space 2} 1.698283{col 45}{space 2} 1.954806{col 56}{space 1}    0.87{col 65}{space 3}0.385{col 73}{space 4}-2.141262{col 86}{space 3} 5.537829
{txt}{space 26}2013  {c |}{col 33}{res}{space 2} 2.118784{col 45}{space 2} 1.636843{col 56}{space 1}    1.29{col 65}{space 3}0.196{col 73}{space 4}-1.096231{col 86}{space 3} 5.333799
{txt}{space 26}2014  {c |}{col 33}{res}{space 2} 2.945226{col 45}{space 2} 1.731786{col 56}{space 1}    1.70{col 65}{space 3}0.090{col 73}{space 4}-.4562734{col 86}{space 3} 6.346726
{txt}{space 26}2015  {c |}{col 33}{res}{space 2} 4.593851{col 45}{space 2} 1.502586{col 56}{space 1}    3.06{col 65}{space 3}0.002{col 73}{space 4} 1.642538{col 86}{space 3} 7.545164
{txt}{space 26}2016  {c |}{col 33}{res}{space 2}        0{col 45}{txt}  (omitted)
{space 26}2017  {c |}{col 33}{res}{space 2}-1.050963{col 45}{space 2} 5.453994{col 56}{space 1}   -0.19{col 65}{space 3}0.847{col 73}{space 4}-11.76346{col 86}{space 3} 9.661536
{txt}{space 26}2018  {c |}{col 33}{res}{space 2}  3.94487{col 45}{space 2} 6.421952{col 56}{space 1}    0.61{col 65}{space 3}0.539{col 73}{space 4} -8.66885{col 86}{space 3} 16.55859
{txt}{space 26}2019  {c |}{col 33}{res}{space 2} 14.26534{col 45}{space 2} 7.255709{col 56}{space 1}    1.97{col 65}{space 3}0.050{col 73}{space 4} .0139931{col 86}{space 3} 28.51669
{txt}{space 26}2020  {c |}{col 33}{res}{space 2}  15.2516{col 45}{space 2} 10.62092{col 56}{space 1}    1.44{col 65}{space 3}0.152{col 73}{space 4} -5.60954{col 86}{space 3} 36.11274
{txt}{space 31} {c |}
{space 26}_cons {c |}{col 33}{res}{space 2}-111.6112{col 45}{space 2}   350.84{col 56}{space 1}   -0.32{col 65}{space 3}0.751{col 73}{space 4}-800.7159{col 86}{space 3} 577.4935
{txt}{hline 32}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                        sigma_u {c |} {res} 24.371486
                        {txt}sigma_e {c |} {res} 48.806272
                            {txt}rho {c |} {res} .19958503{txt}   (fraction of variance due to u_i)
{hline 32}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_demdummy, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_demdummy.tex"'"':R1_final_fed_act_con_demdummy.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_demdummy.txt""':seeout}

{com}. 
. xtreg fed_act_yr_city_2012_pc i.str_mayor_pres_gover_party##i.pres_dem c.ln_tot_pop#i.pres_dem c.ln_income_pc#i.pres_dem c.pov_rate#i.pres_dem i.year, fe vce(cluster geo_fips)
{p 0 6 2}{txt}note: 2016.year omitted because of collinearity{p_end}
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     8,022
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       568

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0291{col 63}{txt}min{col 67}={col 69}{res}         2
{txt}     between = {res}0.0566{col 63}{txt}avg{col 67}={col 69}{res}      14.1
{txt}     overall = {res}0.0227{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}23{txt},{res}567{txt}){col 67}={col 70}{res}    11.32
{txt}corr(u_i, Xb){col 16}= {res}-0.4630{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 94:(Std. Err. adjusted for {res:568} clusters in geo_fips)}
{hline 29}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 30}{c |}{col 42}    Robust
{col 1}     fed_act_yr_city_2012_pc{col 30}{c |}      Coef.{col 42}   Std. Err.{col 54}      t{col 62}   P>|t|{col 70}     [95% Con{col 83}f. Interval]
{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.str_mayor_pres_gover_party {c |}{col 30}{res}{space 2} 2.056253{col 42}{space 2} 2.150556{col 53}{space 1}    0.96{col 62}{space 3}0.339{col 70}{space 4}-2.167775{col 83}{space 3} 6.280282
{txt}{space 18}1.pres_dem {c |}{col 30}{res}{space 2} 87.14478{col 42}{space 2} 71.03929{col 53}{space 1}    1.23{col 62}{space 3}0.220{col 70}{space 4}-52.38751{col 83}{space 3} 226.6771
{txt}{space 28} {c |}
{space 2}str_mayor_pres_gover_party#{c |}
{space 20}pres_dem {c |}
{space 24}1 1  {c |}{col 30}{res}{space 2} 6.475614{col 42}{space 2} 3.731688{col 53}{space 1}    1.74{col 62}{space 3}0.083{col 70}{space 4}-.8540054{col 83}{space 3} 13.80523
{txt}{space 28} {c |}
{space 7}pres_dem#c.ln_tot_pop {c |}
{space 26}0  {c |}{col 30}{res}{space 2} 24.05266{col 42}{space 2} 16.89299{col 53}{space 1}    1.42{col 62}{space 3}0.155{col 70}{space 4}-9.127827{col 83}{space 3} 57.23315
{txt}{space 26}1  {c |}{col 30}{res}{space 2}  21.2267{col 42}{space 2} 16.35778{col 53}{space 1}    1.30{col 62}{space 3}0.195{col 70}{space 4}-10.90256{col 83}{space 3} 53.35595
{txt}{space 28} {c |}
{space 5}pres_dem#c.ln_income_pc {c |}
{space 26}0  {c |}{col 30}{res}{space 2}-16.15366{col 42}{space 2} 24.66956{col 53}{space 1}   -0.65{col 62}{space 3}0.513{col 70}{space 4}-64.60855{col 83}{space 3} 32.30123
{txt}{space 26}1  {c |}{col 30}{res}{space 2}-21.44674{col 42}{space 2} 27.21948{col 53}{space 1}   -0.79{col 62}{space 3}0.431{col 70}{space 4}-74.91006{col 83}{space 3} 32.01658
{txt}{space 28} {c |}
{space 9}pres_dem#c.pov_rate {c |}
{space 26}0  {c |}{col 30}{res}{space 2}-23.88348{col 42}{space 2} 80.47651{col 53}{space 1}   -0.30{col 62}{space 3}0.767{col 70}{space 4} -181.952{col 83}{space 3}  134.185
{txt}{space 26}1  {c |}{col 30}{res}{space 2}-38.81201{col 42}{space 2} 90.44781{col 53}{space 1}   -0.43{col 62}{space 3}0.668{col 70}{space 4}-216.4657{col 83}{space 3} 138.8417
{txt}{space 28} {c |}
{space 24}year {c |}
{space 23}2006  {c |}{col 30}{res}{space 2}-1.221499{col 42}{space 2} 1.786385{col 53}{space 1}   -0.68{col 62}{space 3}0.494{col 70}{space 4}-4.730238{col 83}{space 3} 2.287241
{txt}{space 23}2007  {c |}{col 30}{res}{space 2} 1.656665{col 42}{space 2} 1.988654{col 53}{space 1}    0.83{col 62}{space 3}0.405{col 70}{space 4}-2.249363{col 83}{space 3} 5.562694
{txt}{space 23}2008  {c |}{col 30}{res}{space 2} 21.51542{col 42}{space 2} 2.841591{col 53}{space 1}    7.57{col 62}{space 3}0.000{col 70}{space 4} 15.93409{col 83}{space 3} 27.09675
{txt}{space 23}2009  {c |}{col 30}{res}{space 2} 24.36079{col 42}{space 2} 5.846181{col 53}{space 1}    4.17{col 62}{space 3}0.000{col 70}{space 4} 12.87797{col 83}{space 3}  35.8436
{txt}{space 23}2010  {c |}{col 30}{res}{space 2} 12.92425{col 42}{space 2} 3.141739{col 53}{space 1}    4.11{col 62}{space 3}0.000{col 70}{space 4} 6.753382{col 83}{space 3} 19.09512
{txt}{space 23}2011  {c |}{col 30}{res}{space 2} 11.60239{col 42}{space 2} 2.360175{col 53}{space 1}    4.92{col 62}{space 3}0.000{col 70}{space 4} 6.966632{col 83}{space 3} 16.23814
{txt}{space 23}2012  {c |}{col 30}{res}{space 2} 1.639084{col 42}{space 2} 1.967246{col 53}{space 1}    0.83{col 62}{space 3}0.405{col 70}{space 4}-2.224895{col 83}{space 3} 5.503063
{txt}{space 23}2013  {c |}{col 30}{res}{space 2} 1.978343{col 42}{space 2} 1.644783{col 53}{space 1}    1.20{col 62}{space 3}0.230{col 70}{space 4}-1.252269{col 83}{space 3} 5.208955
{txt}{space 23}2014  {c |}{col 30}{res}{space 2} 2.880598{col 42}{space 2} 1.735556{col 53}{space 1}    1.66{col 62}{space 3}0.098{col 70}{space 4}-.5283061{col 83}{space 3} 6.289501
{txt}{space 23}2015  {c |}{col 30}{res}{space 2} 4.634767{col 42}{space 2}  1.50909{col 53}{space 1}    3.07{col 62}{space 3}0.002{col 70}{space 4} 1.670678{col 83}{space 3} 7.598857
{txt}{space 23}2016  {c |}{col 30}{res}{space 2}        0{col 42}{txt}  (omitted)
{space 23}2017  {c |}{col 30}{res}{space 2}-.9602197{col 42}{space 2} 5.432053{col 53}{space 1}   -0.18{col 62}{space 3}0.860{col 70}{space 4}-11.62962{col 83}{space 3} 9.709183
{txt}{space 23}2018  {c |}{col 30}{res}{space 2} 4.046585{col 42}{space 2} 6.400606{col 53}{space 1}    0.63{col 62}{space 3}0.527{col 70}{space 4}-8.525208{col 83}{space 3} 16.61838
{txt}{space 23}2019  {c |}{col 30}{res}{space 2}  14.3386{col 42}{space 2} 7.228614{col 53}{space 1}    1.98{col 62}{space 3}0.048{col 70}{space 4} .1404706{col 83}{space 3} 28.53673
{txt}{space 23}2020  {c |}{col 30}{res}{space 2} 15.32847{col 42}{space 2} 10.59034{col 53}{space 1}    1.45{col 62}{space 3}0.148{col 70}{space 4}-5.472622{col 83}{space 3} 36.12957
{txt}{space 28} {c |}
{space 23}_cons {c |}{col 30}{res}{space 2}-106.3462{col 42}{space 2} 350.2488{col 53}{space 1}   -0.30{col 62}{space 3}0.762{col 70}{space 4}-794.2897{col 83}{space 3} 581.5972
{txt}{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                     sigma_u {c |} {res}  24.39097
                     {txt}sigma_e {c |} {res} 48.806055
                         {txt}rho {c |} {res}  .1998419{txt}   (fraction of variance due to u_i)
{hline 29}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_con_demdummy, tex drop(i.geo_fips i.year) ctitle("Total, Per capita (con $)") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_con_demdummy.tex"'"':R1_final_fed_act_con_demdummy.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_con_demdummy.txt""':seeout}

{com}. 
. 
. 
. ** Table B.7 **
. 
. xtreg ln_fed_act_yr_city_2012 i.mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     5,402
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       542

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1140{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.4407{col 63}{txt}avg{col 67}={col 69}{res}      10.0
{txt}     overall = {res}0.3196{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}541{txt}){col 67}={col 70}{res}    35.14
{txt}corr(u_i, Xb){col 16}= {res}0.0573{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 84:(Std. Err. adjusted for {res:542} clusters in geo_fips)}
{hline 19}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 20}{c |}{col 32}    Robust
{col 1}ln_fed_act_yr~2012{col 20}{c |}      Coef.{col 32}   Std. Err.{col 44}      t{col 52}   P>|t|{col 60}     [95% Con{col 73}f. Interval]
{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_party {c |}{col 20}{res}{space 2} .0603075{col 32}{space 2} .0470887{col 43}{space 1}    1.28{col 52}{space 3}0.201{col 60}{space 4}-.0321916{col 73}{space 3} .1528067
{txt}{space 8}ln_tot_pop {c |}{col 20}{res}{space 2} 1.172703{col 32}{space 2} .4924457{col 43}{space 1}    2.38{col 52}{space 3}0.018{col 60}{space 4} .2053627{col 73}{space 3} 2.140043
{txt}{space 6}ln_income_pc {c |}{col 20}{res}{space 2} -1.28552{col 32}{space 2} .6941502{col 43}{space 1}   -1.85{col 52}{space 3}0.065{col 60}{space 4} -2.64908{col 73}{space 3} .0780403
{txt}{space 10}pov_rate {c |}{col 20}{res}{space 2}-4.377153{col 32}{space 2} 3.067755{col 43}{space 1}   -1.43{col 52}{space 3}0.154{col 60}{space 4}-10.40332{col 73}{space 3} 1.649017
{txt}{space 18} {c |}
{space 14}year {c |}
{space 13}2006  {c |}{col 20}{res}{space 2} .3802118{col 32}{space 2} .1050724{col 43}{space 1}    3.62{col 52}{space 3}0.000{col 60}{space 4}  .173812{col 73}{space 3} .5866116
{txt}{space 13}2007  {c |}{col 20}{res}{space 2} .1139112{col 32}{space 2} .1294126{col 43}{space 1}    0.88{col 52}{space 3}0.379{col 60}{space 4}-.1403016{col 73}{space 3} .3681241
{txt}{space 13}2008  {c |}{col 20}{res}{space 2} 1.179948{col 32}{space 2} .1280912{col 43}{space 1}    9.21{col 52}{space 3}0.000{col 60}{space 4} .9283309{col 73}{space 3} 1.431565
{txt}{space 13}2009  {c |}{col 20}{res}{space 2}    1.297{col 32}{space 2} .1169153{col 43}{space 1}   11.09{col 52}{space 3}0.000{col 60}{space 4} 1.067337{col 73}{space 3} 1.526664
{txt}{space 13}2010  {c |}{col 20}{res}{space 2} .9001645{col 32}{space 2} .1212214{col 43}{space 1}    7.43{col 52}{space 3}0.000{col 60}{space 4} .6620422{col 73}{space 3} 1.138287
{txt}{space 13}2011  {c |}{col 20}{res}{space 2} .9646818{col 32}{space 2} .1339486{col 43}{space 1}    7.20{col 52}{space 3}0.000{col 60}{space 4} .7015587{col 73}{space 3} 1.227805
{txt}{space 13}2012  {c |}{col 20}{res}{space 2} .0508571{col 32}{space 2} .1499019{col 43}{space 1}    0.34{col 52}{space 3}0.735{col 60}{space 4}-.2436041{col 73}{space 3} .3453182
{txt}{space 13}2013  {c |}{col 20}{res}{space 2} .0178727{col 32}{space 2} .1531044{col 43}{space 1}    0.12{col 52}{space 3}0.907{col 60}{space 4}-.2828792{col 73}{space 3} .3186246
{txt}{space 13}2014  {c |}{col 20}{res}{space 2} .0979232{col 32}{space 2} .1595088{col 43}{space 1}    0.61{col 52}{space 3}0.540{col 60}{space 4}-.2154092{col 73}{space 3} .4112556
{txt}{space 13}2015  {c |}{col 20}{res}{space 2} .3008925{col 32}{space 2} .1588401{col 43}{space 1}    1.89{col 52}{space 3}0.059{col 60}{space 4}-.0111264{col 73}{space 3} .6129114
{txt}{space 13}2016  {c |}{col 20}{res}{space 2} .0593813{col 32}{space 2} .1785702{col 43}{space 1}    0.33{col 52}{space 3}0.740{col 60}{space 4}-.2913947{col 73}{space 3} .4101572
{txt}{space 13}2017  {c |}{col 20}{res}{space 2}-.0120113{col 32}{space 2} .1915895{col 43}{space 1}   -0.06{col 52}{space 3}0.950{col 60}{space 4}-.3883617{col 73}{space 3} .3643392
{txt}{space 13}2018  {c |}{col 20}{res}{space 2} .3781174{col 32}{space 2}  .210312{col 43}{space 1}    1.80{col 52}{space 3}0.073{col 60}{space 4}-.0350108{col 73}{space 3} .7912456
{txt}{space 13}2019  {c |}{col 20}{res}{space 2} .5669903{col 32}{space 2}  .239776{col 43}{space 1}    2.36{col 52}{space 3}0.018{col 60}{space 4} .0959842{col 73}{space 3} 1.037996
{txt}{space 13}2020  {c |}{col 20}{res}{space 2} .5906672{col 32}{space 2} .2540052{col 43}{space 1}    2.33{col 52}{space 3}0.020{col 60}{space 4} .0917099{col 73}{space 3} 1.089625
{txt}{space 18} {c |}
{space 13}_cons {c |}{col 20}{res}{space 2} 12.96207{col 32}{space 2} 9.325623{col 43}{space 1}    1.39{col 52}{space 3}0.165{col 60}{space 4}-5.356798{col 73}{space 3} 31.28094
{txt}{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
           sigma_u {c |} {res} 1.0385771
           {txt}sigma_e {c |} {res} 1.3366806
               {txt}rho {c |} {res} .37644254{txt}   (fraction of variance due to u_i)
{hline 19}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln, tex drop(i.geo_fips i.year) ctitle("Total, Logged") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) replace
{txt}{stata `"shellout using `"R1_final_fed_act_ln.tex"'"':R1_final_fed_act_ln.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln.txt""':seeout}

{com}. 
. xtreg ln_fed_act_yr_city_2012 i.strong_mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     5,402
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       542

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1148{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.4414{col 63}{txt}avg{col 67}={col 69}{res}      10.0
{txt}     overall = {res}0.3212{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}541{txt}){col 67}={col 70}{res}    36.82
{txt}corr(u_i, Xb){col 16}= {res}0.0549{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:542} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  ln_fed_act_yr_city_2012{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.strong_mayor_pres_party {c |}{col 27}{res}{space 2} .1440119{col 39}{space 2} .0650678{col 50}{space 1}    2.21{col 59}{space 3}0.027{col 67}{space 4} .0161954{col 80}{space 3} .2718285
{txt}{space 15}ln_tot_pop {c |}{col 27}{res}{space 2} 1.177404{col 39}{space 2} .4913502{col 50}{space 1}    2.40{col 59}{space 3}0.017{col 67}{space 4} .2122162{col 80}{space 3} 2.142592
{txt}{space 13}ln_income_pc {c |}{col 27}{res}{space 2}-1.264627{col 39}{space 2} .6920721{col 50}{space 1}   -1.83{col 59}{space 3}0.068{col 67}{space 4}-2.624105{col 80}{space 3} .0948505
{txt}{space 17}pov_rate {c |}{col 27}{res}{space 2}-4.413896{col 39}{space 2} 3.059346{col 50}{space 1}   -1.44{col 59}{space 3}0.150{col 67}{space 4}-10.42355{col 80}{space 3} 1.595756
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2006  {c |}{col 27}{res}{space 2} .3818461{col 39}{space 2} .1049714{col 50}{space 1}    3.64{col 59}{space 3}0.000{col 67}{space 4} .1756446{col 80}{space 3} .5880477
{txt}{space 20}2007  {c |}{col 27}{res}{space 2} .1132819{col 39}{space 2} .1293145{col 50}{space 1}    0.88{col 59}{space 3}0.381{col 67}{space 4}-.1407382{col 80}{space 3}  .367302
{txt}{space 20}2008  {c |}{col 27}{res}{space 2} 1.175373{col 39}{space 2} .1283838{col 50}{space 1}    9.16{col 59}{space 3}0.000{col 67}{space 4} .9231815{col 80}{space 3} 1.427565
{txt}{space 20}2009  {c |}{col 27}{res}{space 2} 1.290487{col 39}{space 2} .1164981{col 50}{space 1}   11.08{col 59}{space 3}0.000{col 67}{space 4} 1.061643{col 80}{space 3} 1.519331
{txt}{space 20}2010  {c |}{col 27}{res}{space 2} .8922405{col 39}{space 2} .1209428{col 50}{space 1}    7.38{col 59}{space 3}0.000{col 67}{space 4} .6546654{col 80}{space 3} 1.129816
{txt}{space 20}2011  {c |}{col 27}{res}{space 2} .9558474{col 39}{space 2} .1341508{col 50}{space 1}    7.13{col 59}{space 3}0.000{col 67}{space 4} .6923271{col 80}{space 3} 1.219368
{txt}{space 20}2012  {c |}{col 27}{res}{space 2}  .043751{col 39}{space 2} .1490056{col 50}{space 1}    0.29{col 59}{space 3}0.769{col 67}{space 4}-.2489495{col 80}{space 3} .3364514
{txt}{space 20}2013  {c |}{col 27}{res}{space 2} .0107206{col 39}{space 2} .1522546{col 50}{space 1}    0.07{col 59}{space 3}0.944{col 67}{space 4} -.288362{col 80}{space 3} .3098033
{txt}{space 20}2014  {c |}{col 27}{res}{space 2} .0923729{col 39}{space 2} .1587771{col 50}{space 1}    0.58{col 59}{space 3}0.561{col 67}{space 4}-.2195222{col 80}{space 3}  .404268
{txt}{space 20}2015  {c |}{col 27}{res}{space 2} .2974482{col 39}{space 2} .1580906{col 50}{space 1}    1.88{col 59}{space 3}0.060{col 67}{space 4}-.0130984{col 80}{space 3} .6079949
{txt}{space 20}2016  {c |}{col 27}{res}{space 2} .0544324{col 39}{space 2} .1785785{col 50}{space 1}    0.30{col 59}{space 3}0.761{col 67}{space 4}-.2963597{col 80}{space 3} .4052246
{txt}{space 20}2017  {c |}{col 27}{res}{space 2}-.0152402{col 39}{space 2} .1912623{col 50}{space 1}   -0.08{col 59}{space 3}0.937{col 67}{space 4}-.3909481{col 80}{space 3} .3604676
{txt}{space 20}2018  {c |}{col 27}{res}{space 2} .3702661{col 39}{space 2} .2102633{col 50}{space 1}    1.76{col 59}{space 3}0.079{col 67}{space 4}-.0427665{col 80}{space 3} .7832987
{txt}{space 20}2019  {c |}{col 27}{res}{space 2} .5594101{col 39}{space 2} .2395836{col 50}{space 1}    2.33{col 59}{space 3}0.020{col 67}{space 4} .0887821{col 80}{space 3} 1.030038
{txt}{space 20}2020  {c |}{col 27}{res}{space 2} .5814345{col 39}{space 2} .2535802{col 50}{space 1}    2.29{col 59}{space 3}0.022{col 67}{space 4}  .083312{col 80}{space 3} 1.079557
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2} 12.70365{col 39}{space 2} 9.288837{col 50}{space 1}    1.37{col 59}{space 3}0.172{col 67}{space 4} -5.54296{col 80}{space 3} 30.95025
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 1.0377979
                  {txt}sigma_e {c |} {res}  1.336081
                      {txt}rho {c |} {res} .37630084{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln, tex drop(i.geo_fips i.year) ctitle("Total, Logged") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln.tex"'"':R1_final_fed_act_ln.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln.txt""':seeout}

{com}. 
. xtreg ln_fed_act_yr_city_2012 i.mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     5,402
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       542

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1157{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.4373{col 63}{txt}avg{col 67}={col 69}{res}      10.0
{txt}     overall = {res}0.3193{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}541{txt}){col 67}={col 70}{res}    35.80
{txt}corr(u_i, Xb){col 16}= {res}0.1023{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 90:(Std. Err. adjusted for {res:542} clusters in geo_fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 26}{c |}{col 38}    Robust
{col 1} ln_fed_act_yr_city_2012{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_gover_party {c |}{col 26}{res}{space 2} .1631656{col 38}{space 2} .0538275{col 49}{space 1}    3.03{col 58}{space 3}0.003{col 66}{space 4} .0574292{col 79}{space 3} .2689021
{txt}{space 14}ln_tot_pop {c |}{col 26}{res}{space 2} 1.109471{col 38}{space 2} .4919042{col 49}{space 1}    2.26{col 58}{space 3}0.025{col 66}{space 4} .1431948{col 79}{space 3} 2.075747
{txt}{space 12}ln_income_pc {c |}{col 26}{res}{space 2}-1.227986{col 38}{space 2} .6920283{col 49}{space 1}   -1.77{col 58}{space 3}0.077{col 66}{space 4}-2.587377{col 79}{space 3} .1314061
{txt}{space 16}pov_rate {c |}{col 26}{res}{space 2}-3.957186{col 38}{space 2} 3.063308{col 49}{space 1}   -1.29{col 58}{space 3}0.197{col 66}{space 4}-9.974622{col 79}{space 3} 2.060251
{txt}{space 24} {c |}
{space 20}year {c |}
{space 19}2006  {c |}{col 26}{res}{space 2} .3833368{col 38}{space 2} .1051696{col 49}{space 1}    3.64{col 58}{space 3}0.000{col 66}{space 4}  .176746{col 79}{space 3} .5899275
{txt}{space 19}2007  {c |}{col 26}{res}{space 2} .1172664{col 38}{space 2} .1289173{col 49}{space 1}    0.91{col 58}{space 3}0.363{col 66}{space 4}-.1359734{col 79}{space 3} .3705061
{txt}{space 19}2008  {c |}{col 26}{res}{space 2} 1.179207{col 38}{space 2} .1278765{col 49}{space 1}    9.22{col 58}{space 3}0.000{col 66}{space 4}  .928012{col 79}{space 3} 1.430403
{txt}{space 19}2009  {c |}{col 26}{res}{space 2}  1.29417{col 38}{space 2} .1158384{col 49}{space 1}   11.17{col 58}{space 3}0.000{col 66}{space 4} 1.066622{col 79}{space 3} 1.521719
{txt}{space 19}2010  {c |}{col 26}{res}{space 2} .8992926{col 38}{space 2}  .120327{col 49}{space 1}    7.47{col 58}{space 3}0.000{col 66}{space 4} .6629273{col 79}{space 3} 1.135658
{txt}{space 19}2011  {c |}{col 26}{res}{space 2} .9673094{col 38}{space 2} .1324669{col 49}{space 1}    7.30{col 58}{space 3}0.000{col 66}{space 4} .7070969{col 79}{space 3} 1.227522
{txt}{space 19}2012  {c |}{col 26}{res}{space 2} .0483052{col 38}{space 2} .1488018{col 49}{space 1}    0.32{col 58}{space 3}0.746{col 66}{space 4}-.2439949{col 79}{space 3} .3406053
{txt}{space 19}2013  {c |}{col 26}{res}{space 2} .0224524{col 38}{space 2} .1517954{col 49}{space 1}    0.15{col 58}{space 3}0.882{col 66}{space 4}-.2757282{col 79}{space 3}  .320633
{txt}{space 19}2014  {c |}{col 26}{res}{space 2} .0964697{col 38}{space 2} .1585424{col 49}{space 1}    0.61{col 58}{space 3}0.543{col 66}{space 4}-.2149644{col 79}{space 3} .4079038
{txt}{space 19}2015  {c |}{col 26}{res}{space 2} .3085635{col 38}{space 2} .1573392{col 49}{space 1}    1.96{col 58}{space 3}0.050{col 66}{space 4} -.000507{col 79}{space 3} .6176341
{txt}{space 19}2016  {c |}{col 26}{res}{space 2}  .067366{col 38}{space 2} .1769449{col 49}{space 1}    0.38{col 58}{space 3}0.704{col 66}{space 4}-.2802173{col 79}{space 3} .4149492
{txt}{space 19}2017  {c |}{col 26}{res}{space 2}-.0207681{col 38}{space 2} .1915585{col 49}{space 1}   -0.11{col 58}{space 3}0.914{col 66}{space 4}-.3970576{col 79}{space 3} .3555214
{txt}{space 19}2018  {c |}{col 26}{res}{space 2} .3694527{col 38}{space 2} .2096459{col 49}{space 1}    1.76{col 58}{space 3}0.079{col 66}{space 4} -.042367{col 79}{space 3} .7812724
{txt}{space 19}2019  {c |}{col 26}{res}{space 2} .5635124{col 38}{space 2} .2390248{col 49}{space 1}    2.36{col 58}{space 3}0.019{col 66}{space 4} .0939819{col 79}{space 3} 1.033043
{txt}{space 19}2020  {c |}{col 26}{res}{space 2} .5888713{col 38}{space 2} .2527668{col 49}{space 1}    2.33{col 58}{space 3}0.020{col 66}{space 4} .0923466{col 79}{space 3} 1.085396
{txt}{space 24} {c |}
{space 19}_cons {c |}{col 26}{res}{space 2} 13.08229{col 38}{space 2}   9.2826{col 49}{space 1}    1.41{col 58}{space 3}0.159{col 66}{space 4}-5.152068{col 79}{space 3} 31.31664
{txt}{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                 sigma_u {c |} {res} 1.0446477
                 {txt}sigma_e {c |} {res} 1.3354095
                     {txt}rho {c |} {res} .37963055{txt}   (fraction of variance due to u_i)
{hline 25}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln, tex drop(i.geo_fips i.year) ctitle("Total, Logged") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln.tex"'"':R1_final_fed_act_ln.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln.txt""':seeout}

{com}. 
. xtreg ln_fed_act_yr_city_2012 i.str_mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     5,402
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       542

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1153{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.4376{col 63}{txt}avg{col 67}={col 69}{res}      10.0
{txt}     overall = {res}0.3199{col 63}{txt}max{col 67}={col 69}{res}        16

{txt}{col 49}F({res}19{txt},{res}541{txt}){col 67}={col 70}{res}    37.12
{txt}corr(u_i, Xb){col 16}= {res}0.0866{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 94:(Std. Err. adjusted for {res:542} clusters in geo_fips)}
{hline 29}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 30}{c |}{col 42}    Robust
{col 1}     ln_fed_act_yr_city_2012{col 30}{c |}      Coef.{col 42}   Std. Err.{col 54}      t{col 62}   P>|t|{col 70}     [95% Con{col 83}f. Interval]
{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.str_mayor_pres_gover_party {c |}{col 30}{res}{space 2} .2176423{col 42}{space 2} .0784098{col 53}{space 1}    2.78{col 62}{space 3}0.006{col 70}{space 4} .0636174{col 83}{space 3} .3716672
{txt}{space 18}ln_tot_pop {c |}{col 30}{res}{space 2} 1.131707{col 42}{space 2} .4899963{col 53}{space 1}    2.31{col 62}{space 3}0.021{col 70}{space 4} .1691782{col 83}{space 3} 2.094235
{txt}{space 16}ln_income_pc {c |}{col 30}{res}{space 2}-1.241848{col 42}{space 2} .6927326{col 53}{space 1}   -1.79{col 62}{space 3}0.074{col 70}{space 4}-2.602623{col 83}{space 3} .1189277
{txt}{space 20}pov_rate {c |}{col 30}{res}{space 2}-4.221814{col 42}{space 2} 3.061602{col 53}{space 1}   -1.38{col 62}{space 3}0.168{col 70}{space 4} -10.2359{col 83}{space 3} 1.792269
{txt}{space 28} {c |}
{space 24}year {c |}
{space 23}2006  {c |}{col 30}{res}{space 2}  .382304{col 42}{space 2} .1049067{col 53}{space 1}    3.64{col 62}{space 3}0.000{col 70}{space 4} .1762297{col 83}{space 3} .5883783
{txt}{space 23}2007  {c |}{col 30}{res}{space 2} .1143421{col 42}{space 2}  .129351{col 53}{space 1}    0.88{col 62}{space 3}0.377{col 70}{space 4}-.1397495{col 83}{space 3} .3684338
{txt}{space 23}2008  {c |}{col 30}{res}{space 2} 1.178156{col 42}{space 2} .1283456{col 53}{space 1}    9.18{col 62}{space 3}0.000{col 70}{space 4} .9260391{col 83}{space 3} 1.430273
{txt}{space 23}2009  {c |}{col 30}{res}{space 2} 1.298545{col 42}{space 2} .1159679{col 53}{space 1}   11.20{col 62}{space 3}0.000{col 70}{space 4} 1.070742{col 83}{space 3} 1.526348
{txt}{space 23}2010  {c |}{col 30}{res}{space 2} .9011415{col 42}{space 2} .1207123{col 53}{space 1}    7.47{col 62}{space 3}0.000{col 70}{space 4} .6640193{col 83}{space 3} 1.138264
{txt}{space 23}2011  {c |}{col 30}{res}{space 2} .9618332{col 42}{space 2} .1336932{col 53}{space 1}    7.19{col 62}{space 3}0.000{col 70}{space 4} .6992119{col 83}{space 3} 1.224455
{txt}{space 23}2012  {c |}{col 30}{res}{space 2} .0490452{col 42}{space 2} .1489792{col 53}{space 1}    0.33{col 62}{space 3}0.742{col 70}{space 4}-.2436034{col 83}{space 3} .3416938
{txt}{space 23}2013  {c |}{col 30}{res}{space 2} .0176774{col 42}{space 2} .1521387{col 53}{space 1}    0.12{col 62}{space 3}0.908{col 70}{space 4}-.2811775{col 83}{space 3} .3165324
{txt}{space 23}2014  {c |}{col 30}{res}{space 2}  .095327{col 42}{space 2} .1587408{col 53}{space 1}    0.60{col 62}{space 3}0.548{col 70}{space 4}-.2164968{col 83}{space 3} .4071508
{txt}{space 23}2015  {c |}{col 30}{res}{space 2} .3148304{col 42}{space 2} .1570776{col 53}{space 1}    2.00{col 62}{space 3}0.046{col 70}{space 4} .0062736{col 83}{space 3} .6233871
{txt}{space 23}2016  {c |}{col 30}{res}{space 2} .0728568{col 42}{space 2} .1772473{col 53}{space 1}    0.41{col 62}{space 3}0.681{col 70}{space 4}-.2753205{col 83}{space 3}  .421034
{txt}{space 23}2017  {c |}{col 30}{res}{space 2} -.020959{col 42}{space 2} .1916861{col 53}{space 1}   -0.11{col 62}{space 3}0.913{col 70}{space 4}-.3974991{col 83}{space 3} .3555812
{txt}{space 23}2018  {c |}{col 30}{res}{space 2}  .368166{col 42}{space 2} .2102023{col 53}{space 1}    1.75{col 62}{space 3}0.080{col 70}{space 4}-.0447468{col 83}{space 3} .7810788
{txt}{space 23}2019  {c |}{col 30}{res}{space 2} .5589161{col 42}{space 2} .2396192{col 53}{space 1}    2.33{col 62}{space 3}0.020{col 70}{space 4} .0882181{col 83}{space 3} 1.029614
{txt}{space 23}2020  {c |}{col 30}{res}{space 2} .5792904{col 42}{space 2} .2534333{col 53}{space 1}    2.29{col 62}{space 3}0.023{col 70}{space 4} .0814566{col 83}{space 3} 1.077124
{txt}{space 28} {c |}
{space 23}_cons {c |}{col 30}{res}{space 2} 12.99852{col 42}{space 2} 9.247177{col 53}{space 1}    1.41{col 62}{space 3}0.160{col 70}{space 4}-5.166255{col 83}{space 3} 31.16329
{txt}{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                     sigma_u {c |} {res} 1.0430936
                     {txt}sigma_e {c |} {res} 1.3356887
                         {txt}rho {c |} {res} .37883115{txt}   (fraction of variance due to u_i)
{hline 29}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln, tex drop(i.geo_fips i.year) ctitle("Total, Logged") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln.tex"'"':R1_final_fed_act_ln.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln.txt""':seeout}

{com}. 
. 
. 
. ** Table B.8 **
. xtreg ln_fed_act_yr_city_2012 i.mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,863
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       506

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1652{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3441{col 63}{txt}avg{col 67}={col 69}{res}       5.7
{txt}     overall = {res}0.2933{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}505{txt}){col 67}={col 70}{res}    33.91
{txt}corr(u_i, Xb){col 16}= {res}-0.2884{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 84:(Std. Err. adjusted for {res:506} clusters in geo_fips)}
{hline 19}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 20}{c |}{col 32}    Robust
{col 1}ln_fed_act_yr~2012{col 20}{c |}      Coef.{col 32}   Std. Err.{col 44}      t{col 52}   P>|t|{col 60}     [95% Con{col 73}f. Interval]
{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_party {c |}{col 20}{res}{space 2} .0973298{col 32}{space 2} .1228537{col 43}{space 1}    0.79{col 52}{space 3}0.429{col 60}{space 4}-.1440375{col 73}{space 3}  .338697
{txt}{space 8}ln_tot_pop {c |}{col 20}{res}{space 2} 1.464591{col 32}{space 2} 1.019999{col 43}{space 1}    1.44{col 52}{space 3}0.152{col 60}{space 4}-.5393725{col 73}{space 3} 3.468555
{txt}{space 6}ln_income_pc {c |}{col 20}{res}{space 2}-3.623409{col 32}{space 2} 1.328156{col 43}{space 1}   -2.73{col 52}{space 3}0.007{col 60}{space 4}-6.232801{col 73}{space 3}-1.014017
{txt}{space 10}pov_rate {c |}{col 20}{res}{space 2}-9.672088{col 32}{space 2} 5.624327{col 43}{space 1}   -1.72{col 52}{space 3}0.086{col 60}{space 4}-20.72205{col 73}{space 3} 1.377874
{txt}{space 18} {c |}
{space 14}year {c |}
{space 13}2010  {c |}{col 20}{res}{space 2}-.3329115{col 32}{space 2} .0812835{col 43}{space 1}   -4.10{col 52}{space 3}0.000{col 60}{space 4}-.4926069{col 73}{space 3}-.1732162
{txt}{space 13}2011  {c |}{col 20}{res}{space 2}-.1976386{col 32}{space 2}  .101016{col 43}{space 1}   -1.96{col 52}{space 3}0.051{col 60}{space 4}-.3961021{col 73}{space 3} .0008248
{txt}{space 13}2012  {c |}{col 20}{res}{space 2} -1.11965{col 32}{space 2}  .128611{col 43}{space 1}   -8.71{col 52}{space 3}0.000{col 60}{space 4}-1.372329{col 73}{space 3}-.8669717
{txt}{space 13}2013  {c |}{col 20}{res}{space 2} -1.13833{col 32}{space 2}  .146316{col 43}{space 1}   -7.78{col 52}{space 3}0.000{col 60}{space 4}-1.425793{col 73}{space 3}-.8508665
{txt}{space 13}2014  {c |}{col 20}{res}{space 2}-1.036259{col 32}{space 2} .1674788{col 43}{space 1}   -6.19{col 52}{space 3}0.000{col 60}{space 4}  -1.3653{col 73}{space 3}-.7072178
{txt}{space 13}2015  {c |}{col 20}{res}{space 2}-.7849536{col 32}{space 2} .1636846{col 43}{space 1}   -4.80{col 52}{space 3}0.000{col 60}{space 4} -1.10654{col 73}{space 3}-.4633669
{txt}{space 13}2016  {c |}{col 20}{res}{space 2}-1.011575{col 32}{space 2} .1941173{col 43}{space 1}   -5.21{col 52}{space 3}0.000{col 60}{space 4}-1.392952{col 73}{space 3}-.6301984
{txt}{space 18} {c |}
{space 13}_cons {c |}{col 20}{res}{space 2} 34.79276{col 32}{space 2} 18.50331{col 43}{space 1}    1.88{col 52}{space 3}0.061{col 60}{space 4}-1.560188{col 73}{space 3}  71.1457
{txt}{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
           sigma_u {c |} {res} 1.2476868
           {txt}sigma_e {c |} {res} 1.2472806
               {txt}rho {c |} {res} .50016278{txt}   (fraction of variance due to u_i)
{hline 19}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) replace
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. xtreg ln_fed_act_yr_city_2012 i.mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year  if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,539
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       521

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0878{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3859{col 63}{txt}avg{col 67}={col 69}{res}       4.9
{txt}     overall = {res}0.3098{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}520{txt}){col 67}={col 70}{res}    18.45
{txt}corr(u_i, Xb){col 16}= {res}0.0881{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 84:(Std. Err. adjusted for {res:521} clusters in geo_fips)}
{hline 19}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 20}{c |}{col 32}    Robust
{col 1}ln_fed_act_yr~2012{col 20}{c |}      Coef.{col 32}   Std. Err.{col 44}      t{col 52}   P>|t|{col 60}     [95% Con{col 73}f. Interval]
{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_party {c |}{col 20}{res}{space 2}-.0852954{col 32}{space 2} .1246705{col 43}{space 1}   -0.68{col 52}{space 3}0.494{col 60}{space 4}-.3302151{col 73}{space 3} .1596244
{txt}{space 8}ln_tot_pop {c |}{col 20}{res}{space 2} 1.147869{col 32}{space 2} .6016866{col 43}{space 1}    1.91{col 52}{space 3}0.057{col 60}{space 4}-.0341659{col 73}{space 3} 2.329904
{txt}{space 6}ln_income_pc {c |}{col 20}{res}{space 2} -.710296{col 32}{space 2}  .913406{col 43}{space 1}   -0.78{col 52}{space 3}0.437{col 60}{space 4}-2.504715{col 73}{space 3} 1.084123
{txt}{space 10}pov_rate {c |}{col 20}{res}{space 2}-4.421828{col 32}{space 2} 4.162534{col 43}{space 1}   -1.06{col 52}{space 3}0.289{col 60}{space 4}-12.59928{col 73}{space 3} 3.755623
{txt}{space 18} {c |}
{space 14}year {c |}
{space 13}2006  {c |}{col 20}{res}{space 2} .3675043{col 32}{space 2} .1046755{col 43}{space 1}    3.51{col 52}{space 3}0.000{col 60}{space 4} .1618655{col 73}{space 3}  .573143
{txt}{space 13}2007  {c |}{col 20}{res}{space 2} .0930617{col 32}{space 2} .1391112{col 43}{space 1}    0.67{col 52}{space 3}0.504{col 60}{space 4}-.1802273{col 73}{space 3} .3663507
{txt}{space 13}2008  {c |}{col 20}{res}{space 2} 1.142896{col 32}{space 2} .1455809{col 43}{space 1}    7.85{col 52}{space 3}0.000{col 60}{space 4} .8568975{col 73}{space 3} 1.428895
{txt}{space 13}2017  {c |}{col 20}{res}{space 2}-.1362115{col 32}{space 2} .2390148{col 43}{space 1}   -0.57{col 52}{space 3}0.569{col 60}{space 4}-.6057648{col 73}{space 3} .3333419
{txt}{space 13}2018  {c |}{col 20}{res}{space 2} .2357182{col 32}{space 2} .2642732{col 43}{space 1}    0.89{col 52}{space 3}0.373{col 60}{space 4}-.2834561{col 73}{space 3} .7548924
{txt}{space 13}2019  {c |}{col 20}{res}{space 2} .3973958{col 32}{space 2} .3045397{col 43}{space 1}    1.30{col 52}{space 3}0.193{col 60}{space 4}-.2008836{col 73}{space 3} .9956751
{txt}{space 13}2020  {c |}{col 20}{res}{space 2} .4028302{col 32}{space 2} .3202398{col 43}{space 1}    1.26{col 52}{space 3}0.209{col 60}{space 4}-.2262927{col 73}{space 3} 1.031953
{txt}{space 18} {c |}
{space 13}_cons {c |}{col 20}{res}{space 2} 7.563519{col 32}{space 2} 12.10913{col 43}{space 1}    0.62{col 52}{space 3}0.532{col 60}{space 4}-16.22532{col 73}{space 3} 31.35236
{txt}{hline 19}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
           sigma_u {c |} {res} 1.2080224
           {txt}sigma_e {c |} {res} 1.3713531
               {txt}rho {c |} {res} .43693108{txt}   (fraction of variance due to u_i)
{hline 19}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. 
. xtreg ln_fed_act_yr_city_2012 i.strong_mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,863
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       506

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1649{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3337{col 63}{txt}avg{col 67}={col 69}{res}       5.7
{txt}     overall = {res}0.2873{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}505{txt}){col 67}={col 70}{res}    33.99
{txt}corr(u_i, Xb){col 16}= {res}-0.2703{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:506} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  ln_fed_act_yr_city_2012{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.strong_mayor_pres_party {c |}{col 27}{res}{space 2} .0324739{col 39}{space 2} .1148413{col 50}{space 1}    0.28{col 59}{space 3}0.777{col 67}{space 4}-.1931518{col 80}{space 3} .2580995
{txt}{space 15}ln_tot_pop {c |}{col 27}{res}{space 2} 1.428559{col 39}{space 2} 1.017439{col 50}{space 1}    1.40{col 59}{space 3}0.161{col 67}{space 4}-.5703755{col 80}{space 3} 3.427493
{txt}{space 13}ln_income_pc {c |}{col 27}{res}{space 2}-3.591913{col 39}{space 2} 1.326112{col 50}{space 1}   -2.71{col 59}{space 3}0.007{col 67}{space 4} -6.19729{col 80}{space 3}-.9865374
{txt}{space 17}pov_rate {c |}{col 27}{res}{space 2}-9.671748{col 39}{space 2} 5.641725{col 50}{space 1}   -1.71{col 59}{space 3}0.087{col 67}{space 4}-20.75589{col 80}{space 3} 1.412395
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2010  {c |}{col 27}{res}{space 2}-.3343991{col 39}{space 2} .0815698{col 50}{space 1}   -4.10{col 59}{space 3}0.000{col 67}{space 4}-.4946571{col 80}{space 3}-.1741411
{txt}{space 20}2011  {c |}{col 27}{res}{space 2}-.1996441{col 39}{space 2} .1015692{col 50}{space 1}   -1.97{col 59}{space 3}0.050{col 67}{space 4}-.3991943{col 80}{space 3}-.0000938
{txt}{space 20}2012  {c |}{col 27}{res}{space 2}-1.120336{col 39}{space 2} .1288577{col 50}{space 1}   -8.69{col 59}{space 3}0.000{col 67}{space 4}-1.373499{col 80}{space 3}-.8671726
{txt}{space 20}2013  {c |}{col 27}{res}{space 2}-1.138883{col 39}{space 2} .1465083{col 50}{space 1}   -7.77{col 59}{space 3}0.000{col 67}{space 4}-1.426723{col 80}{space 3}-.8510417
{txt}{space 20}2014  {c |}{col 27}{res}{space 2}-1.035085{col 39}{space 2} .1676137{col 50}{space 1}   -6.18{col 59}{space 3}0.000{col 67}{space 4}-1.364391{col 80}{space 3}-.7057786
{txt}{space 20}2015  {c |}{col 27}{res}{space 2}-.7843163{col 39}{space 2} .1637494{col 50}{space 1}   -4.79{col 59}{space 3}0.000{col 67}{space 4} -1.10603{col 80}{space 3}-.4626023
{txt}{space 20}2016  {c |}{col 27}{res}{space 2}-1.012561{col 39}{space 2} .1941969{col 50}{space 1}   -5.21{col 59}{space 3}0.000{col 67}{space 4}-1.394094{col 80}{space 3}-.6310277
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2} 34.94875{col 39}{space 2} 18.52894{col 50}{space 1}    1.89{col 59}{space 3}0.060{col 67}{space 4}-1.454543{col 80}{space 3} 71.35205
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 1.2497921
                  {txt}sigma_e {c |} {res}  1.247474
                      {txt}rho {c |} {res} .50092828{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. xtreg ln_fed_act_yr_city_2012 i.strong_mayor_pres_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,539
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       521

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0879{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3836{col 63}{txt}avg{col 67}={col 69}{res}       4.9
{txt}     overall = {res}0.3083{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}520{txt}){col 67}={col 70}{res}    18.29
{txt}corr(u_i, Xb){col 16}= {res}0.0933{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 91:(Std. Err. adjusted for {res:521} clusters in geo_fips)}
{hline 26}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 27}{c |}{col 39}    Robust
{col 1}  ln_fed_act_yr_city_2012{col 27}{c |}      Coef.{col 39}   Std. Err.{col 51}      t{col 59}   P>|t|{col 67}     [95% Con{col 80}f. Interval]
{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.strong_mayor_pres_party {c |}{col 27}{res}{space 2}-.1344435{col 39}{space 2} .2136538{col 50}{space 1}   -0.63{col 59}{space 3}0.529{col 67}{space 4}-.5541742{col 80}{space 3} .2852872
{txt}{space 15}ln_tot_pop {c |}{col 27}{res}{space 2}  1.13656{col 39}{space 2} .6046493{col 50}{space 1}    1.88{col 59}{space 3}0.061{col 67}{space 4}-.0512953{col 80}{space 3} 2.324416
{txt}{space 13}ln_income_pc {c |}{col 27}{res}{space 2}-.7234768{col 39}{space 2} .9140813{col 50}{space 1}   -0.79{col 59}{space 3}0.429{col 67}{space 4}-2.519223{col 80}{space 3} 1.072269
{txt}{space 17}pov_rate {c |}{col 27}{res}{space 2}-4.291447{col 39}{space 2} 4.147383{col 50}{space 1}   -1.03{col 59}{space 3}0.301{col 67}{space 4}-12.43913{col 80}{space 3} 3.856239
{txt}{space 25} {c |}
{space 21}year {c |}
{space 20}2006  {c |}{col 27}{res}{space 2} .3670693{col 39}{space 2} .1048137{col 50}{space 1}    3.50{col 59}{space 3}0.001{col 67}{space 4}  .161159{col 80}{space 3} .5729797
{txt}{space 20}2007  {c |}{col 27}{res}{space 2} .0903479{col 39}{space 2} .1387498{col 50}{space 1}    0.65{col 59}{space 3}0.515{col 67}{space 4}-.1822311{col 80}{space 3}  .362927
{txt}{space 20}2008  {c |}{col 27}{res}{space 2} 1.144122{col 39}{space 2} .1453938{col 50}{space 1}    7.87{col 59}{space 3}0.000{col 67}{space 4}  .858491{col 80}{space 3} 1.429754
{txt}{space 20}2017  {c |}{col 27}{res}{space 2}-.1359293{col 39}{space 2} .2389192{col 50}{space 1}   -0.57{col 59}{space 3}0.570{col 67}{space 4}-.6052947{col 80}{space 3} .3334361
{txt}{space 20}2018  {c |}{col 27}{res}{space 2} .2390189{col 39}{space 2} .2641152{col 50}{space 1}    0.90{col 59}{space 3}0.366{col 67}{space 4}-.2798451{col 80}{space 3} .7578829
{txt}{space 20}2019  {c |}{col 27}{res}{space 2} .4028535{col 39}{space 2} .3047516{col 50}{space 1}    1.32{col 59}{space 3}0.187{col 67}{space 4}-.1958422{col 80}{space 3} 1.001549
{txt}{space 20}2020  {c |}{col 27}{res}{space 2} .4097358{col 39}{space 2} .3204676{col 50}{space 1}    1.28{col 59}{space 3}0.202{col 67}{space 4}-.2198345{col 80}{space 3} 1.039306
{txt}{space 25} {c |}
{space 20}_cons {c |}{col 27}{res}{space 2} 7.808117{col 39}{space 2}  12.1359{col 50}{space 1}    0.64{col 59}{space 3}0.520{col 67}{space 4} -16.0333{col 80}{space 3} 31.64953
{txt}{hline 26}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                  sigma_u {c |} {res} 1.2106842
                  {txt}sigma_e {c |} {res} 1.3712609
                      {txt}rho {c |} {res} .43804751{txt}   (fraction of variance due to u_i)
{hline 26}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. 
. xtreg ln_fed_act_yr_city_2012 i.mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,863
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       506

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1666{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3328{col 63}{txt}avg{col 67}={col 69}{res}       5.7
{txt}     overall = {res}0.2888{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}505{txt}){col 67}={col 70}{res}    34.65
{txt}corr(u_i, Xb){col 16}= {res}-0.2313{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 90:(Std. Err. adjusted for {res:506} clusters in geo_fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 26}{c |}{col 38}    Robust
{col 1} ln_fed_act_yr_city_2012{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_gover_party {c |}{col 26}{res}{space 2} .1747789{col 38}{space 2} .0745044{col 49}{space 1}    2.35{col 58}{space 3}0.019{col 66}{space 4} .0284021{col 79}{space 3} .3211556
{txt}{space 14}ln_tot_pop {c |}{col 26}{res}{space 2} 1.356217{col 38}{space 2} 1.018645{col 49}{space 1}    1.33{col 58}{space 3}0.184{col 66}{space 4}-.6450877{col 79}{space 3} 3.357521
{txt}{space 12}ln_income_pc {c |}{col 26}{res}{space 2}-3.562863{col 38}{space 2} 1.326989{col 49}{space 1}   -2.68{col 58}{space 3}0.007{col 66}{space 4}-6.169962{col 79}{space 3} -.955764
{txt}{space 16}pov_rate {c |}{col 26}{res}{space 2} -9.38111{col 38}{space 2} 5.627606{col 49}{space 1}   -1.67{col 58}{space 3}0.096{col 66}{space 4}-20.43751{col 79}{space 3} 1.675294
{txt}{space 24} {c |}
{space 20}year {c |}
{space 19}2010  {c |}{col 26}{res}{space 2}-.3299031{col 38}{space 2} .0816063{col 49}{space 1}   -4.04{col 58}{space 3}0.000{col 66}{space 4}-.4902328{col 79}{space 3}-.1695735
{txt}{space 19}2011  {c |}{col 26}{res}{space 2}-.1907376{col 38}{space 2} .1008166{col 49}{space 1}   -1.89{col 58}{space 3}0.059{col 66}{space 4}-.3888092{col 79}{space 3}  .007334
{txt}{space 19}2012  {c |}{col 26}{res}{space 2}-1.114041{col 38}{space 2} .1283054{col 49}{space 1}   -8.68{col 58}{space 3}0.000{col 66}{space 4}-1.366119{col 79}{space 3}-.8619629
{txt}{space 19}2013  {c |}{col 26}{res}{space 2}-1.127664{col 38}{space 2} .1456299{col 49}{space 1}   -7.74{col 58}{space 3}0.000{col 66}{space 4}-1.413779{col 79}{space 3}-.8415487
{txt}{space 19}2014  {c |}{col 26}{res}{space 2} -1.02998{col 38}{space 2} .1667128{col 49}{space 1}   -6.18{col 58}{space 3}0.000{col 66}{space 4}-1.357516{col 79}{space 3}-.7024438
{txt}{space 19}2015  {c |}{col 26}{res}{space 2}-.7684739{col 38}{space 2} .1634496{col 49}{space 1}   -4.70{col 58}{space 3}0.000{col 66}{space 4}-1.089599{col 79}{space 3} -.447349
{txt}{space 19}2016  {c |}{col 26}{res}{space 2}-.9946733{col 38}{space 2}  .193075{col 49}{space 1}   -5.15{col 58}{space 3}0.000{col 66}{space 4}-1.374003{col 79}{space 3}-.6153441
{txt}{space 24} {c |}
{space 19}_cons {c |}{col 26}{res}{space 2} 35.43701{col 38}{space 2} 18.52438{col 49}{space 1}    1.91{col 58}{space 3}0.056{col 66}{space 4}-.9573399{col 79}{space 3} 71.83135
{txt}{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                 sigma_u {c |} {res} 1.2367905
                 {txt}sigma_e {c |} {res} 1.2462345
                     {txt}rho {c |} {res} .49619664{txt}   (fraction of variance due to u_i)
{hline 25}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. xtreg ln_fed_act_yr_city_2012 i.mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,539
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       521

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0881{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3644{col 63}{txt}avg{col 67}={col 69}{res}       4.9
{txt}     overall = {res}0.2988{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}520{txt}){col 67}={col 70}{res}    18.47
{txt}corr(u_i, Xb){col 16}= {res}0.1073{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 90:(Std. Err. adjusted for {res:521} clusters in geo_fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 26}{c |}{col 38}    Robust
{col 1} ln_fed_act_yr_city_2012{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.mayor_pres_gover_party {c |}{col 26}{res}{space 2} .1321626{col 38}{space 2}  .127899{col 49}{space 1}    1.03{col 58}{space 3}0.302{col 66}{space 4}-.1190998{col 79}{space 3} .3834249
{txt}{space 14}ln_tot_pop {c |}{col 26}{res}{space 2} 1.099258{col 38}{space 2}  .606921{col 49}{space 1}    1.81{col 58}{space 3}0.071{col 66}{space 4}-.0930604{col 79}{space 3} 2.291577
{txt}{space 12}ln_income_pc {c |}{col 26}{res}{space 2}-.7397532{col 38}{space 2} .9158697{col 49}{space 1}   -0.81{col 58}{space 3}0.420{col 66}{space 4}-2.539013{col 79}{space 3} 1.059506
{txt}{space 16}pov_rate {c |}{col 26}{res}{space 2} -4.12232{col 38}{space 2} 4.139718{col 49}{space 1}   -1.00{col 58}{space 3}0.320{col 66}{space 4}-12.25495{col 79}{space 3} 4.010307
{txt}{space 24} {c |}
{space 20}year {c |}
{space 19}2006  {c |}{col 26}{res}{space 2} .3696177{col 38}{space 2} .1048125{col 49}{space 1}    3.53{col 58}{space 3}0.000{col 66}{space 4} .1637097{col 79}{space 3} .5755256
{txt}{space 19}2007  {c |}{col 26}{res}{space 2} .0955181{col 38}{space 2} .1384951{col 49}{space 1}    0.69{col 58}{space 3}0.491{col 66}{space 4}-.1765607{col 79}{space 3} .3675968
{txt}{space 19}2008  {c |}{col 26}{res}{space 2} 1.149844{col 38}{space 2} .1457377{col 49}{space 1}    7.89{col 58}{space 3}0.000{col 66}{space 4} .8635367{col 79}{space 3} 1.436151
{txt}{space 19}2017  {c |}{col 26}{res}{space 2}-.1336716{col 38}{space 2} .2398977{col 49}{space 1}   -0.56{col 58}{space 3}0.578{col 66}{space 4}-.6049594{col 79}{space 3} .3376162
{txt}{space 19}2018  {c |}{col 26}{res}{space 2} .2438849{col 38}{space 2} .2648949{col 49}{space 1}    0.92{col 58}{space 3}0.358{col 66}{space 4}-.2765108{col 79}{space 3} .7642807
{txt}{space 19}2019  {c |}{col 26}{res}{space 2} .4142582{col 38}{space 2} .3050536{col 49}{space 1}    1.36{col 58}{space 3}0.175{col 66}{space 4}-.1850307{col 79}{space 3} 1.013547
{txt}{space 19}2020  {c |}{col 26}{res}{space 2} .4258061{col 38}{space 2} .3201865{col 49}{space 1}    1.33{col 58}{space 3}0.184{col 66}{space 4} -.203212{col 79}{space 3} 1.054824
{txt}{space 24} {c |}
{space 19}_cons {c |}{col 26}{res}{space 2} 8.355971{col 38}{space 2} 12.13745{col 49}{space 1}    0.69{col 58}{space 3}0.491{col 66}{space 4}-15.48849{col 79}{space 3} 32.20044
{txt}{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                 sigma_u {c |} {res}  1.229794
                 {txt}sigma_e {c |} {res} 1.3711376
                     {txt}rho {c |} {res} .44581656{txt}   (fraction of variance due to u_i)
{hline 25}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. 
. xtreg ln_fed_act_yr_city_2012 i.str_mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==1, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,863
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       506

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.1654{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3239{col 63}{txt}avg{col 67}={col 69}{res}       5.7
{txt}     overall = {res}0.2823{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}505{txt}){col 67}={col 70}{res}    34.14
{txt}corr(u_i, Xb){col 16}= {res}-0.2319{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 94:(Std. Err. adjusted for {res:506} clusters in geo_fips)}
{hline 29}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 30}{c |}{col 42}    Robust
{col 1}     ln_fed_act_yr_city_2012{col 30}{c |}      Coef.{col 42}   Std. Err.{col 54}      t{col 62}   P>|t|{col 70}     [95% Con{col 83}f. Interval]
{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.str_mayor_pres_gover_party {c |}{col 30}{res}{space 2}   .13105{col 42}{space 2} .1190839{col 53}{space 1}    1.10{col 62}{space 3}0.272{col 70}{space 4}-.1029108{col 83}{space 3} .3650109
{txt}{space 18}ln_tot_pop {c |}{col 30}{res}{space 2} 1.338308{col 42}{space 2}  1.02278{col 53}{space 1}    1.31{col 62}{space 3}0.191{col 70}{space 4}-.6711196{col 83}{space 3} 3.347736
{txt}{space 16}ln_income_pc {c |}{col 30}{res}{space 2}-3.593529{col 42}{space 2} 1.325483{col 53}{space 1}   -2.71{col 62}{space 3}0.007{col 70}{space 4}-6.197669{col 83}{space 3}-.9893893
{txt}{space 20}pov_rate {c |}{col 30}{res}{space 2}-9.571682{col 42}{space 2} 5.615726{col 53}{space 1}   -1.70{col 62}{space 3}0.089{col 70}{space 4}-20.60474{col 83}{space 3} 1.461381
{txt}{space 28} {c |}
{space 24}year {c |}
{space 23}2010  {c |}{col 30}{res}{space 2}-.3322625{col 42}{space 2} .0816255{col 53}{space 1}   -4.07{col 62}{space 3}0.000{col 70}{space 4}-.4926298{col 83}{space 3}-.1718952
{txt}{space 23}2011  {c |}{col 30}{res}{space 2} -.198914{col 42}{space 2} .1010553{col 53}{space 1}   -1.97{col 62}{space 3}0.050{col 70}{space 4}-.3974545{col 83}{space 3}-.0003735
{txt}{space 23}2012  {c |}{col 30}{res}{space 2}-1.117995{col 42}{space 2} .1283234{col 53}{space 1}   -8.71{col 62}{space 3}0.000{col 70}{space 4}-1.370108{col 83}{space 3}-.8658811
{txt}{space 23}2013  {c |}{col 30}{res}{space 2}-1.135806{col 42}{space 2}  .145855{col 53}{space 1}   -7.79{col 62}{space 3}0.000{col 70}{space 4}-1.422364{col 83}{space 3} -.849249
{txt}{space 23}2014  {c |}{col 30}{res}{space 2}-1.033336{col 42}{space 2} .1667826{col 53}{space 1}   -6.20{col 62}{space 3}0.000{col 70}{space 4}-1.361009{col 83}{space 3}-.7056623
{txt}{space 23}2015  {c |}{col 30}{res}{space 2}-.7721448{col 42}{space 2} .1635888{col 53}{space 1}   -4.72{col 62}{space 3}0.000{col 70}{space 4}-1.093543{col 83}{space 3}-.4507463
{txt}{space 23}2016  {c |}{col 30}{res}{space 2} -.999528{col 42}{space 2} .1929209{col 53}{space 1}   -5.18{col 62}{space 3}0.000{col 70}{space 4}-1.378554{col 83}{space 3}-.6205016
{txt}{space 28} {c |}
{space 23}_cons {c |}{col 30}{res}{space 2} 36.01144{col 42}{space 2} 18.46676{col 53}{space 1}    1.95{col 62}{space 3}0.052{col 70}{space 4}-.2696965{col 83}{space 3} 72.29257
{txt}{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                     sigma_u {c |} {res}  1.245061
                     {txt}sigma_e {c |} {res} 1.2471201
                         {txt}rho {c |} {res} .49917379{txt}   (fraction of variance due to u_i)
{hline 29}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Dem Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. xtreg ln_fed_act_yr_city_2012 i.str_mayor_pres_gover_party ln_tot_pop ln_income_pc pov_rate i.year if pres_dem==0, fe vce(cluster geo_fips)
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}     2,539
{txt}Group variable: {res}geo_fips{txt}{col 49}Number of groups{col 67}={col 69}{res}       521

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.0879{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.3676{col 63}{txt}avg{col 67}={col 69}{res}       4.9
{txt}     overall = {res}0.3006{col 63}{txt}max{col 67}={col 69}{res}         8

{txt}{col 49}F({res}11{txt},{res}520{txt}){col 67}={col 70}{res}    18.57
{txt}corr(u_i, Xb){col 16}= {res}0.0960{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{ralign 94:(Std. Err. adjusted for {res:521} clusters in geo_fips)}
{hline 29}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 30}{c |}{col 42}    Robust
{col 1}     ln_fed_act_yr_city_2012{col 30}{c |}      Coef.{col 42}   Std. Err.{col 54}      t{col 62}   P>|t|{col 70}     [95% Con{col 83}f. Interval]
{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
1.str_mayor_pres_gover_party {c |}{col 30}{res}{space 2} .1540288{col 42}{space 2} .2471775{col 53}{space 1}    0.62{col 62}{space 3}0.533{col 70}{space 4}-.3315605{col 83}{space 3}  .639618
{txt}{space 18}ln_tot_pop {c |}{col 30}{res}{space 2} 1.121632{col 42}{space 2} .6045125{col 53}{space 1}    1.86{col 62}{space 3}0.064{col 70}{space 4}-.0659551{col 83}{space 3} 2.309218
{txt}{space 16}ln_income_pc {c |}{col 30}{res}{space 2}-.7257004{col 42}{space 2} .9179305{col 53}{space 1}   -0.79{col 62}{space 3}0.430{col 70}{space 4}-2.529008{col 83}{space 3} 1.077608
{txt}{space 20}pov_rate {c |}{col 30}{res}{space 2}-4.434483{col 42}{space 2}  4.15958{col 53}{space 1}   -1.07{col 62}{space 3}0.287{col 70}{space 4}-12.60613{col 83}{space 3} 3.737164
{txt}{space 28} {c |}
{space 24}year {c |}
{space 23}2006  {c |}{col 30}{res}{space 2}  .369142{col 42}{space 2} .1045803{col 53}{space 1}    3.53{col 62}{space 3}0.000{col 70}{space 4} .1636901{col 83}{space 3} .5745938
{txt}{space 23}2007  {c |}{col 30}{res}{space 2} .0944976{col 42}{space 2} .1384919{col 53}{space 1}    0.68{col 62}{space 3}0.495{col 70}{space 4}-.1775747{col 83}{space 3} .3665699
{txt}{space 23}2008  {c |}{col 30}{res}{space 2} 1.147059{col 42}{space 2} .1452571{col 53}{space 1}    7.90{col 62}{space 3}0.000{col 70}{space 4} .8616963{col 83}{space 3} 1.432422
{txt}{space 23}2017  {c |}{col 30}{res}{space 2}-.1350043{col 42}{space 2}  .240793{col 53}{space 1}   -0.56{col 62}{space 3}0.575{col 70}{space 4} -.608051{col 83}{space 3} .3380424
{txt}{space 23}2018  {c |}{col 30}{res}{space 2} .2397397{col 42}{space 2}  .266092{col 53}{space 1}    0.90{col 62}{space 3}0.368{col 70}{space 4}-.2830078{col 83}{space 3} .7624871
{txt}{space 23}2019  {c |}{col 30}{res}{space 2} .4042182{col 42}{space 2} .3065444{col 53}{space 1}    1.32{col 62}{space 3}0.188{col 70}{space 4}-.1979995{col 83}{space 3} 1.006436
{txt}{space 23}2020  {c |}{col 30}{res}{space 2} .4124017{col 42}{space 2} .3217415{col 53}{space 1}    1.28{col 62}{space 3}0.200{col 70}{space 4}-.2196712{col 83}{space 3} 1.044475
{txt}{space 28} {c |}
{space 23}_cons {c |}{col 30}{res}{space 2} 7.989949{col 42}{space 2} 12.14715{col 53}{space 1}    0.66{col 62}{space 3}0.511{col 70}{space 4}-15.87356{col 83}{space 3} 31.85346
{txt}{hline 29}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                     sigma_u {c |} {res} 1.2258419
                     {txt}sigma_e {c |} {res} 1.3712733
                         {txt}rho {c |} {res} .44417777{txt}   (fraction of variance due to u_i)
{hline 29}{c BT}{hline 64}

{com}. outreg2 using R1_final_fed_act_ln_presparty, tex drop(i.geo_fips i.year) ctitle("Total, Logged, Rep Pres") addnote("Note: clustered standard errors at city level.") addtext(City FE, YES, Year FE, YES) append
{res}warning: addnote ignored in appended columns
{txt}{stata `"shellout using `"R1_final_fed_act_ln_presparty.tex"'"':R1_final_fed_act_ln_presparty.tex}
{browse `"F:\fiscal research\mayor\grant"' :dir}{com} : {txt}{stata `"seeout using "R1_final_fed_act_ln_presparty.txt""':seeout}

{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}F:\fiscal research\mayor\PSRM data\PSRM_Analaysis_log.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}19 Dec 2023, 09:24:42
{txt}{.-}
{smcl}
{txt}{sf}{ul off}